Quote:
Originally Posted by NBVC
That would require VBA.
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.
|
Wow My mind is really whirring now.
Sorry to be a nuisance but which bit of the formula (which A) do I need to replace with the name of the sheet?
Thanks again
Rob