I am creating a table which is filled by data extracted from another table. After extraction, the data is totalled before transfer takes place. The data to be transferred is then on one row and extends across several columns.
I would like to know if there is a function within Excel XP which will scan down the rows of the receiving table, find the first empty row and copy the transferring data into it. This process would need to continue with the transfer of successive sets of data into the next available empty rows in the receiving table.