Hi all,
I hope you guys are able to help out with this macro. I have attached a workbook, where Sheet 1 contains the raw data. (In the real example there will be a variable no. of rows/columns of data).
'Company Code', 'RM' & 'Charge Amounts' form the set of 3 columns on the sheet that I need to copy & paste into Sheet 2. The macro should be able to copy the subsequent 3 columns also to Sheet 2 (Company Code (1) , RM (1), Charge Amounts (1)..so on. It should essentially follow a loop until there's no more columns left to be copied.
Once all data is collected on Sheet 2, a sort needs to occur by Company Code. I think I can handle this part.
But any help with copying in a loop will be appreciated.
Thanks,
Anya
Bookmarks