weaselmcguff
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 246
We have a rather large file that exports 256 columns of data. We want to use VBA to copy 14 of the columns to another sheet. The columns are scattered through out the entire workbook. I have the code created to create the new sheet. Now I am trying to figure out how to copy the entire column to the new sheet. Problem is the columns are never in the same order when the file is exported. Today Customer could be column A tomorrow it is d.
some of the columns we are trying to copy are
Customer, Parts, Action, Area, Owner, Standard Fault, Qty, TI, TU, etc
Any suggestions?
some of the columns we are trying to copy are
Customer, Parts, Action, Area, Owner, Standard Fault, Qty, TI, TU, etc
Any suggestions?