I click a cell in sheet 1 and run a macro that sends it to my sheet 2. This works fine. I determine which cell based upon the fact that it is an original and I need to add variations of that cell which will be done in sheet 2. This works fine.

I take things from one sheet (spreadsheet 1 containing all the rows of data) to a form sheet set up as a data entry form. Easier to look at one record in a form configuration than a spreadsheet that has columns a thru z and a boatload of rows. This works fine.

The whole program works good as it stands... but as it stands I return data to sheet 1 address "A7" thru "Z7" every time from sheet 2 row "A3" thru "Z3 ". What I want to do is copy data from sheet 2 (row "A3" thru "Z3 ") to an inserted row above the original copied row on sheet 1....and have the inserted row be the active row.

If I am able to accomplish what I want, the only constant will be the address of the copied data from sheet 2 (sheet 2 row "A3" thru "Z3 ") The row to paste that data on sheet 1 will always be a variable determined by the row I select for modification on sheet 2.