Soldato
- Joined
- 21 Jan 2010
- Posts
- 3,571
I have one sheet with a single project reference number per row.
What want is a formula that will pull each project reference number to a separate sheet on 3 consecutive rows. I can then sort their other stuff with indexmatches into a proper table.
I know I can dumb paste rows, but I want to formula it, so it updates as the other sheet does.
Like this
P1
P1
P1
P2
P2
P2
Etc
*yeah, I know, it was another one of those "I wouldn't start from here" conversations.
What want is a formula that will pull each project reference number to a separate sheet on 3 consecutive rows. I can then sort their other stuff with indexmatches into a proper table.
I know I can dumb paste rows, but I want to formula it, so it updates as the other sheet does.
Like this
P1
P1
P1
P2
P2
P2
Etc
*yeah, I know, it was another one of those "I wouldn't start from here" conversations.