How are you determining what original data row to copy?


I have large list of items that I downloaded from the internet that need to be modified. However I need to maintain a copy of the original.

Where do you put it on sheet2?
The data from sheet 1 is loaded into a form like configuration on sheet 2 for modification.

How do you manipulate the data? Manually or existing macro?
I use macros that I have made by recording and some which you and Jeffrey Brown have assisted me.

How do you insert the manipulated data back into sheet1?
Sheets("sheet 2").Range("A3:Z3").Copy
Sheets("sheet 1").Range("A7").Rows("1:1").Insert Shift:=xlDown

On a small spreadsheet this works fine, however it gets quite awkward with a large spreadsheet. I can function as it is but it would be more efficient and less cumbersome if I can reinsert the modified version above the original.

Why are you doing all this?
Helping someone...gratis

Have you used the macro recorder to get an idea of how this would go in a macro?
The problem with macro recorder is that it does not take into account that each time it will be a different row that must be inserted and pasted into.

I understand if you are a bit tired of contributing to my effort. Regardless, you have made significant contribution to my project and I appreciate all that you have offered.