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.

Please Login or Register  to view this content.
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