W
Wombat
I want to make a formula in a summary table which will do a search in all the
other tabs in my work book.
The cell I want the information from is the same in each tab.
My problem is that at the moment, I am having to work on each formula to put
in the tab name in by hand. For example:
=sum(AAA!a1:a2)
=sum(BBB!a1:a2)
Is there a way I can spare myself having to type in the AAA, BBB, CCC part
in? I have all the tab names with the same formatting in the summary table
but I cant use a cell reference in the formula (eg: =sum('A3'!a1:a2))
Any ideas?
Thanks for any help
other tabs in my work book.
The cell I want the information from is the same in each tab.
My problem is that at the moment, I am having to work on each formula to put
in the tab name in by hand. For example:
=sum(AAA!a1:a2)
=sum(BBB!a1:a2)
Is there a way I can spare myself having to type in the AAA, BBB, CCC part
in? I have all the tab names with the same formatting in the summary table
but I cant use a cell reference in the formula (eg: =sum('A3'!a1:a2))
Any ideas?
Thanks for any help