Transfer data to another worksheet only if "Column A" has any value entered

[chris84]

I have a workbook with 2 worksheets - "Customers" and "Orders." What I need is to transfer rows of data from the "Customers" worksheet to the "Orders" worksheet ONLY if "Column A" has an entry in it. If there is no entry in "Column A," I do not want to transfer the data. To complicate to matter I need only selected columns transferred. I need Columns A, H, J, B, and D from "Customers" transfer to the "Orders" worksheet to appear in this particular order: A, H, J, B, D. Any help or suggestions would be greatly appreciated. Thanks, Chris

[Bob Phillips]

Use AUtofilter on column A, then copy and paste the visible rows.

[chris84]

Thanks, but that is not going to put the columns in the order that I need.

[chris84]

The Worksheet "Customers" has 22 columns on it. I only want to copy 8 of those columns onto the "Orders" worksheet but in a different order. I only listed 5 columns in the original post. Once I see how the code is written I will be able to add the other columns. Thanks, Chris.