Hi,
I need some help in creating a macro that will copy selected cells in all worksheets, apart from a couple of worksheets which will not hold the relevant data and paste the data into another worksheet in order for me to create a pivot table.
I.e. I have 3 worksheet called Summary Sheet, Attendance Template and Rawdata which should not be part of copy+paste vba code
What i need is for all remaining worksheets to copy selected cells which would be i4,i5,i6, v4,v5,v6, E13,U13, BM39, BQ39, BV39 and paste into a worksheet called Rawdata starting in Column A, Row 2, Column B, Row 2, Column C, Row 3 and so on..
As the number of worksheets will grow and existing worksheet will be updated. When the macro is run again. i would like it to simply re-write over the "Rawdata" worksheet in order for my pivot table to capture all the latest data when refreshed.
I have attached a sample workbook for easier understanding.
Thanks
BT