How can I automatically sort data in MS excel from one worksheet to another? Copying the entire row of data?

Question

I want to filter using a code number, but still copy over all the data in the selected row to another worksheet. Is this possible, how can I accomplish this.

Answer 1

There is a Function-Based sort technique that you can use
Say your list is in Sheet1 in B2:H10 and you want to sort it in ascending order by the first column (B), then in cell C5 in Sheet2 paste this:
=SMALL( Sheet1!$B:$2:$B$10, ROW() - 4)
then fill this down to get the whole column (B from Sheet1) sorted in C in sheet2.
Then with a traditional VLOOKUP you can get the other columns of the table.

Notice that changing values fromn Sheet1 will make the list in Sheet2 (That is made using SMALL function) to bring the whole list sorted

Yyyyyyaa, I am the VBAXLMan

Answer 2

1

Answer 3

The easiest way is to select the top columns, copy all the selected columns and paste to the others spreadsheet.