Hello!
I'm trying to work with some raw data and the data is organized in the following way:
SHEET1
A name is in cell A8, with an Address on cell A9, a Telephone number on A10.
SHEET2
I want to have a column in the second sheet called "NAMES" and under it, I reference the name on the other sheet by typing ='SHEET1'!A8
But now, I want to reference the next name, which is on A13. How can I make it easy for me to copy and paste a formula, so that it adds the names every 5 cells down? I dont want to manually type in every cell 'SHEET1'!A13, then 'SHEET1'!A18 etc. etc.
What are your suggestions? Thank you for your help!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I'm trying to work with some raw data and the data is organized in the following way:
SHEET1
A name is in cell A8, with an Address on cell A9, a Telephone number on A10.
SHEET2
I want to have a column in the second sheet called "NAMES" and under it, I reference the name on the other sheet by typing ='SHEET1'!A8
But now, I want to reference the next name, which is on A13. How can I make it easy for me to copy and paste a formula, so that it adds the names every 5 cells down? I dont want to manually type in every cell 'SHEET1'!A13, then 'SHEET1'!A18 etc. etc.
What are your suggestions? Thank you for your help!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)