Home » Forums » Open Source Learning Center » Question and Answer

Index across multiple sheets - or a better way (please)

Submitted by maria.griffiths on 25 October, 2012 - 13:21

I have 20 sheets in one workbook all set-up identically that I'm using for source details and from it I need to identify basic information. I have set-up a 21st sheet to provide me with a min rate from within the other sheets which I'm getting - but now need to identify where that rate came from either from the sheet name or from cell a1 in each sheet. Can you advise best way to get this info?

excel help.jpg
‹ Excel-Formatting Tab Name How the copy stock chart from web (such as from finance yahoo) into excel using Excel VBA ›
»
Nick's picture

hi Maria... any reason why

Submitted by Nick on 25 October, 2012 - 16:46.

hi Maria...
any reason why you are not using a pivot table ?

»

No reason

Submitted by maria.griffiths on 25 October, 2012 - 17:08.

Honestly didn't think of that - prob cause I haven't used them much (not proficient at them). Open to suggestions...

»