I have sheets named Wk1, Wk2, Wk3 etc and a Summary sheet.
The Summary sheet has the week numbers going across the sheet in row 3
Below this is a series of calculations (KPIs) performed for each week. However the data used in these formulas comes from a number of different sheets therefore week to week the data could be changed in error for prior weeks and this is my problem.
What I would like to do is have a macro button on the weekly sheets that takes the week number of that sheet (from a cell or from the tab name), looks for that week number along row 3 of the Summary tab. Then copies and pastes as values the calculations below it for instance week 1 would copy and paste values in column B range B4:B6, or week 3 would use D4:D6.
Please bare in mind I am fairly new to VBA.
Thanks
Ad.
Bookmarks