I have used the transpose formula (Array) to extract the data from various sheets (sample data only one sheet)
In Col A on the summary sheet , I have various names which refers to the applicable sheet name
I would like to use the indirect function to combine with the transpose formula using the sheet name in Col A to extract data from B1:B5 for each of the ageing periods
I have tried to use the indirect formula, but get #Ref!
I have attached a sample workbook
Your assistance in resolving this is most appreciated
Bookmarks