Forum Discussion
Expansion
How could one expand a section of data without affecting the below cells by pulling in from another tab via a paste or just entered? To grow without inserting spaces or leaving extra space and delet...
wtw346 Take a look at the attached file.
It has a named range called "RowsInSheet1" that counts the number of rows in Sheet1. The formula in cell A1 in Sheet2 is copied down 1000 rows. The indicator in cell C2 tells you where the last row of the data is.