Copy data if cell has value in it

Hello,

I am looking for help with a macro so I can easily sort and see data.

I have a spreadsheet with rows 1 and 2 containing item information. Rows 3-93 have the ordering information. For every row in 3-93, if there is a value in any column in between F and VU, copy the the corresponding value in columns A,B,C for that row to a new sheet called Orders and copy the corresponding values in rows 1 and 2 for that column.

for example, I need this:

Please Login or Register  to view this content.

Copied over to a new sheet called Orders, like this:

Please Login or Register  to view this content.

I am struggling with the VBA logic and can't seem to get it work right. Any help or advise is greatly appreciated.

Thanks!

In the future, please include a larger sample set. While your example is ample enough to indicate you desired results, testing on such a small sample usually doesn't show any errors, while a larger set might. If unsure, you can always add a sample workbook. (Perferred)

Please Login or Register  to view this content.

This code is dynamic, meaning it will determine last row and last column of the source sheet. So if you have more of fewer rows/columns, it should account for that.