Copy rows from 3 sheets to a 3rd sheet in a certain order
Posted by Melanie Swarner on October 19, 2001 12:11 PM
I am using a filter to extract rows to a section of a sheet. I need to then take those rows put the matching records rom two other sheets in a fourth sheet - like this:
First Row of the Extract (Sheet 3)
Corresponding Row from Sheet 1
Corresponding Row from Sheet 2
Blank Line
Next row of the extract.... and so on....
The rows will always be in the same order in all sheets, but they do not start on the same row (so row 3 of sheet 1 does not equal row 3 of sheets 2 and 3)
Any help is greatly appreciated!
Posted by Gordon Banks on October 19, 2001 3:02 PM
If I understand correctly, the data on sheets 1, 2, and 3 have the same number of rows. If so :-
Copy the data from Sheet3 to Sheet4, insert a column and put sequetial numbers in this column starting with 1 down to the end of the data.
Copy the data from Sheet2 and paste underneath the Sheet4 data. Sequentially number this new data starting with 1.
Repeat this for the Sheet2 data.
Under the Sheet4 data, add sequential numbers starting with 1 and ending with the number of rows in each set of data from the other sheets.
Sort by the column containing the sequential numbers and then delete the column.
