View Single Post
  #2  
Old December 20th, 2003, 06:04 AM
Vasant Nanavati
external usenet poster
 
Posts: n/a
Default 3D formulas to pull across worksheets

Julian; unfortunately I haven't the foggiest understanding of what you want
to accomplish. What do you mean by "returning Value 1", etc.?

Are you just trying to add the same cell across worksheets? If so:

=SUM(Sheet1:Sheet3!B12)

will do it.

--

Vasant


wrote in message
...
I have six workbooks with about 75 tabs each. I want to
return the same values from each of the different tabs,
consolidated on to one tab. Right now we are doing it by
clicking the cells, but it is taking way too long and too
prone to error.

Instead, I need a formula (macro maybe) that will help me
return those values across all the different tabs.
Value 1: Is generally unique, but may exist more than
once, I want to see it returned each time (so if it
appears 3 times, I want to see it three times), because
how it relates to Value 2 is very important.
Value 2: Is unique, but must be kept in connection with
value 1
Value 3: Is unique, but must be kept in connection with
value 1

any ideas without me learning VB in the next 24 hours?