JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
Not quite sure how to explain this...
If I have a sheet with formulas that reference another sheet
A2: =Data!A2
B2: =Data!B2
C2: = Data!C2
If I copy the cells to say A10 it will automatically change them to reference A10 on data sheet.
Though I want
A10: =Data!A3
B10: = Data!B3
C10: = Data!C3
---
A18: =Data!A4
A24: = Data!A5
And repeated every 8 rows, I need to repeat this many times so wondering if there's an easier way, I think maybe using INDIRECT
Appreciate any help
Not quite sure how to explain this...
If I have a sheet with formulas that reference another sheet
A2: =Data!A2
B2: =Data!B2
C2: = Data!C2
If I copy the cells to say A10 it will automatically change them to reference A10 on data sheet.
Though I want
A10: =Data!A3
B10: = Data!B3
C10: = Data!C3
---
A18: =Data!A4
A24: = Data!A5
And repeated every 8 rows, I need to repeat this many times so wondering if there's an easier way, I think maybe using INDIRECT
Appreciate any help