Copy Columns to another sheet based on column heading

Hello All,

Does anyone have an idea on how to copy columns based on a Client's file. I receive files from different clients and the headers are all different. I need a way to copy each column that wont be in the same position from the clients sheet to my generic sheet. I know that I could create a macro for each individual client and run accordingly but i was trying to clean this up a bit. I was possibly thinking about having a table with client name, their field, my field and copy columns. If there is an easier way that would be great.

I have attached a sample work sheet with my table idea.

Thanks for your help

Hi

I think the table is a sensible idea, but I don't think you've laid it out in an optimal way. I think a better way would be to list the Clients just once in Column A, and have the 'My Format' columns as headers along the first row, with the client info for each matching header along the row, like:

My Format Date Description Cost
Client A date_of_sale explanation amount
Client B date desc due
Client C date received info amount due

That way you're reducing duplication of info, and it'll be easier to loop through the relevant columns using VBA.

How would I loop through that in the most efficient way. I am still learning VBA.

I have entered the code to my Workbook. This copies the values from one sheet to another as long as the headings are the same. How could I tweak this in order to look up the client specific column heading in the Table matrix?

Please Login or Register  to view this content.