Quote:
Originally Posted by NBVC
Now in the sheet for Item A, beginning at A2 enter formula:
=IFERROR(INDEX(Results!B:B,MATCH("A"&"_"&ROWS($A$2 :$A2),Results!$F:$F,0)),"")
copied across 4 columns and down as far as you want to capture future data.
Repeat for other items replacing the "A" with the corresponding Item.
Now when you type new row in Results sheet, it would populate in next row of corresponding item.
|
Many thanks for your swift answer NBVC.
I have got the top line ok but I am struggling with the second.
When I put the code into the cell, I am prompted to open a new document! Is this correct?
My sheets are all in the one document.
Also, as there is already some data in some previous weeks cells, and my empty rows are starting in different rows on each item, does this really complicate the issue.
Would it be better to go back to the start date at the end of September (Row 11) and input all of the info into the Result Sheet, one week at a time to build up the historical data.
Thanks
Rob