*** similar to my previous query, but different!****

Howdie!

so situation is

Several Tabs (similar contents but different names) and a consolidated
Tab.
Within the Consolidated tab Cols A to Z each have a unique header (these
are the names of other tabs in the same book)
say Col A = Cat, Col B = Dog etc (ie we thus have a sheets entitled Cat,
dog, etc...)

In the consolidated tab I want to put a formulae In column A that
performs the following calC: From (Tab entitled Cat) , add cell a1 and
cell c3 and then divide by b3.
Now I could just say
=(Cat!a1+:Cat!a1c3)/Cat!b3, but then I would manually have to change cat
to dog
for each of my columns.
I Any ideas???


Regards
D

*** Sent via Developersdex http://www.developersdex.com ***