I have a named range at the top of my worksheet say 6 rows by 8 columns. I need to make a copies of this range as I move down the sheet, insert/delete rows from each copy and proceed down.
The problem is, where I need the new copy I do not wish to scroll to the top of the sheet, copy the range and then scroll back.
I also do not with to do a macro or split the window.
I remember in the days of lotus the copy command sequence was to issue the copy command, provide a "from" range and then a "to" range. I could do this from any location on the spreadsheet by typing range names or cell ranges. I wish to have such an option in excel but cannot find it.