So I'm trying to help someone to set up a spreadsheet where the macro takes the new months data and pastes it into set cells.
I was wanting to use reletive cell reference but am open to ideas.
The problem I'm having is getting the Marco to go back to the starting cell.
The code above is the methodology I'm working on, not the actual code, just trying to get the concept down. My problem is It goes down from the relative starting cell, grabs the info and pastes where I want, but I need to find a way to go back to the starting cell before going down 4 over 1 for the next data.
Is there a code line for something to the effect of Set this location as Start, then I can put in a select Start before the next down/over copy/paste?
~James
Bookmarks