Hi all,
I am trying to create a list of data pulled form multiple worksheets. To do this I am using the indirect function with index match to look for the worksheet name then use a number for the row lookup reference. In the spreadsheet attached, the column H is the reference and is currently manually entered, but need it to be dynamic driven by row C in the table to the left as the values 7 and 5 will change. Essentially I need it to count up from 1 to max of the first value in col c, then 1 to the max of the next value in column c, and so on and more sheets are added to the workbook. The reason for it being dynamic is that the values in col c will constantly change.
Any help much appreciated.
Thanks,
Alex
Bookmarks