Hi folks,
I hit a roadblock when trying to put together a macro. I've searched, quite extensively, for one or a few macros that would achieve what I am trying to do, but with no luck. I am hoping you can guide me in the right direction.
I have a spreadsheet with a couple of sheets - Summary & data sheets. See attached.
The 'Data' sheet contains manually input data, for several week numbers. On the summary sheet I want to see any data pertaining to the current week.
I am trying to put together a macro that will loop through the 'Data' sheet, copy and paste values starting from Cell B8, in the Summary sheet, based on cell B3(week number). The week number is dynamic, hence why cell B3 needs to be referenced.
For example, Cell B3, in the summary sheet, has Week 14. Any data that is in week 14, on the data sheet, has been copied over to the summary sheet...next week will be week 15, so I would like week 15's data to be copied, so on and so forth.
I hope you, excel gurus, can help me out on this.
Bookmarks