OizysChaos
New Member
- Joined
- Jan 24, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I know this is most likely a very basic question but I can't seem to get excel to do exactly what I want to do.
I am using this INDEX formula
=INDEX(Sheet3!A:A, (ROW()-7)*10+1)
To copy information from Sheet3 into Sheet2 which works fine, but I am needing a blank row under each value that is inputted.
In this case I am pulling names from Sheet3 (names appear every ten rows) and copying those names into Sheet2. But I need to have a blank row under each name that is copied over to Sheet2.
Is this possible to have done automatically?
I am using this INDEX formula
=INDEX(Sheet3!A:A, (ROW()-7)*10+1)
To copy information from Sheet3 into Sheet2 which works fine, but I am needing a blank row under each value that is inputted.
In this case I am pulling names from Sheet3 (names appear every ten rows) and copying those names into Sheet2. But I need to have a blank row under each name that is copied over to Sheet2.
Is this possible to have done automatically?