PDA

View Full Version : Transfer data to another worksheet only if "Column A" has any value entered



chris84
12-28-2011, 07:55 AM
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
12-28-2011, 08:24 AM
Use AUtofilter on column A, then copy and paste the visible rows.

chris84
12-28-2011, 08:29 AM
Thanks, but that is not going to put the columns in the order that I need.

chris84
12-28-2011, 08:39 AM
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.