I'm looking for a macro that will copy from "Sheet 1 Range E5" and paste it into "sheet 2 Range B?" I would like to start from B3 check it's clear and paste into there, then the following week, if B3 has a figure then paste into B4 then the following week into B5 etc.
I've heard of cell off set, so googled it, but it's not making much sense for what I have found.
This entire column of B will end up being Weeks 1-52 but I'd like to start at around B3 if possible due to headers and title?
This macro will run in between lines of other macro as a module.
Bookmarks