Reformatting Data dependent on Customer

[jamiem4]

Hi,

I currently receive forms from a number of different customers all in a different format. I am trying to write a macro that will automatically rearrange the data into a predefined template for me.
I think the easiest way would be to have a section of VBA code for each customer that I can then copy to set up for the order the new customer sends data.

For example, for Customer ‘Harry’ (who’s data is in sheet ‘Customer Data’):

If cell A1 in sheet ‘Choose Customer’ = ‘Harry’, copy from A2 to bottom of column A in sheet ‘Customer Data’ and paste into cell D1 of sheet ‘Reformatted Data’

If the Customer was ‘Bob’, copy from C1 to the bottom of column C in sheet ‘Customer Data’ and paste into cell D1 of sheet ‘Reformatted Data’. Etc etc etc.

Please could someone help me to write some code for this?

I hope this makes sense.

Thanks!