TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
I wonder if anyone has a quick fix for my problem.
I have inherited a spreadsheet where every block of two cells has the following formula in
Column A, Rows 2 & 3:
Column A, Rows 4 & 5:
etc etc
I now have to add thousands more of these formula but I can't just copy and paste or drag them because the cell references start drifting.
Is there a quick fix?
Thank you for reading.
I wonder if anyone has a quick fix for my problem.
I have inherited a spreadsheet where every block of two cells has the following formula in
Column A, Rows 2 & 3:
Code:
=IF(ABS(input!F2)>0.001,"Post","Do Not Post")
=IF(ABS(input!F2)>0.001,"Post","Do Not Post")
Column A, Rows 4 & 5:
Code:
=IF(ABS(input!F3)>0.001,"Post","Do Not Post")
=IF(ABS(input!F3)>0.001,"Post","Do Not Post")
etc etc
I now have to add thousands more of these formula but I can't just copy and paste or drag them because the cell references start drifting.
Is there a quick fix?
Thank you for reading.