Hi all,
I have a workbook with approximately 180 worksheets representing different accounts. In column A in the main sheet, there is a list with hyperlinks to all the different sheets. I am hoping for some help on the following problem: Within all these hyperlinked sheets there is a cell (E26) that I need displayed in my mainsheet. When creating this formula manually I use ='111050'!E26 where 'xxxxxx' is the hyperlink located in for example cell A9.
Problem is, I cannot just use the click and drag principle to apply this to the 180 hyperlinks because excel do not define the content of column A as hyperlinks, only numbers. Ergo, I have to do this manually , not just for several hundred accounts, but also multiple companies!
Any ideas on how to solve this matter?