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!
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!
