robertsa123
12-10-2012, 05:12 AM
Hi,
I am new to this so please bare with me. I have a spreadsheet with lots of data held in many sheets. I want to copy the cells A1:A33, F1:F33 and G1:G33 from the sheet WKREPORT and paste them into a new sheet called 'Master Data'. I want to create a macro so that I can do this everytime I have a new spreadsheet sent to me and make changes if I want to. The spreadsheet is in the folder X:\Adam\Sinter Plant Data\Sinter Data 2009 OEE MACRo.
If anyone could suggest a code to do this I'd be very grateful. Please tell me if you need more information.
Thanks,
Adam
I am new to this so please bare with me. I have a spreadsheet with lots of data held in many sheets. I want to copy the cells A1:A33, F1:F33 and G1:G33 from the sheet WKREPORT and paste them into a new sheet called 'Master Data'. I want to create a macro so that I can do this everytime I have a new spreadsheet sent to me and make changes if I want to. The spreadsheet is in the folder X:\Adam\Sinter Plant Data\Sinter Data 2009 OEE MACRo.
If anyone could suggest a code to do this I'd be very grateful. Please tell me if you need more information.
Thanks,
Adam