Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
Hi,
I have a number of formulas copying from another workbook, example one is
='[Value of Money3.xlsx]Income'!$I$1203
I want to copy this formula 40 rows down but only add 1 to the formula so it ends up like
='[Value of Money3.xlsx]Income'!$I$1204
in cell I1243
Can you help me what I need to do please
I appreciate your help.
I have a number of formulas copying from another workbook, example one is
='[Value of Money3.xlsx]Income'!$I$1203
I want to copy this formula 40 rows down but only add 1 to the formula so it ends up like
='[Value of Money3.xlsx]Income'!$I$1204
in cell I1243
Can you help me what I need to do please
I appreciate your help.