fill down a formula

rford63981

I want to fill down a formula. The formula is a cell in a row from a companion sheet. I want to include the cell in a new sheet and fill down like we do in excel. If we want to hold the reference in excel we add a $ sign to the row and column reference - $A$6 which would hold that cell reference for the rows below.

When I reference a cell (formula) from a companion sheet and fill it down it will not reference each row in the fill but remains locked to the first cell referenced.for example I want to fill down  ={Buyer Tracking Range 2} and have it consecutively reference {Buyer Tracking Range 3} to {Buyer Tracking Range nth}

What is the work around?

Paul Newcome

There is no workaround other than to specify each range. The number in your range reference isn't a row or column number but the number assigned to the range. Range 1 could be Row 1, but then you could set range 2 to be a column.