Copying a formula from multiple workbooks down rows and across col
See above.
"Rookie" wrote:
Historically I had thought excell figured these patterns out and replicated
them but for the life of me I can't figure it out.
I have the following formula:=IF('Sales Price'!B3="","",'Sales
Price'!B3/'Sales Price'!F75) that Im trying to copy down multiple rows as
follows::=IF('Sales Price'!B4="","",'Sales Price'!B4/'Sales Price'!F75)
Im also trying to copy it across columns as follows: :=IF('Sales
Price'!C3="","",'Sales Price'!C3/'Sales Price'!F75)
The only real constant needs to be 'Sales Price'!F75, however it changes to
F76 when copying down rows and to G75 when copying across columns. Any help
would be much appreciated!
|