I have a spreadsheet with a list of accounts. (many 000's) Each row has quite a large number of cells and I would like to create a summary sheet showing every row but with only a small number of cells. On the face of it very easy but I need to have it dynamic based on the number of rows.
simple to set up a reference in sheet 2 along the lines of "sheet 1!A1"
Manually I can copy this formula down the rows of sheet 2 to match the number of rows in sheet1
Is there a way to have the reference "dynamic" so that when a new row is added to sheet 1, sheet 2 will be correctly populated.