FREDKIMILU
New Member
- Joined
- Feb 28, 2020
- Messages
- 5
- Office Version
- 2010
- Platform
- Windows
Hi Lovely all,
I'm trying to drag a formula but would like to skip 36 rows.
I have 2 sheets.
Sheet 1 with results and the other with column to attach values from sheet 1
while skipping 36 rows in sheet1.
For example
I want B4 in sheet 2 to pick the value in H4 in sheet1, B5 to pick H40, B6 to pick H76 and so on
such that when i drag the formula B7 will automatically pick the value in H112 in sheet1 etc
Does anyone know how to do this without having to create Macros?
I really hope you can help me: I am working with a big data and attaching every single cell is tedious
Kindly assist
Many thanks
I'm trying to drag a formula but would like to skip 36 rows.
I have 2 sheets.
Sheet 1 with results and the other with column to attach values from sheet 1
while skipping 36 rows in sheet1.
For example
I want B4 in sheet 2 to pick the value in H4 in sheet1, B5 to pick H40, B6 to pick H76 and so on
such that when i drag the formula B7 will automatically pick the value in H112 in sheet1 etc
Does anyone know how to do this without having to create Macros?
I really hope you can help me: I am working with a big data and attaching every single cell is tedious
Kindly assist
Many thanks