Quote:
|
I just want the result sheet to show the latest set of figures and as each week passes, I want to input that weeks data against Item A and for it to show on a new Row in the item sheet.
|
That would require VBA.
Quote:
|
input the new data in it's own sheet and have the result sheet pull that data into the correct cells
|
That can be done with formulas. See attached new sample.
Formula in the Results sheet, starting at B3:
=IFERROR(INDEX(A!A:A,MATCH(10^10,INDIRECT("'"&$A3&"'!$A:$A"))),"")
copied down and across as far as necessary. Note, this requires the item sheetnames to match exactly your list in column A, so that you don't have to hard code the sheetname in each row of formulas.