Is it possible to say something like:

"If column b has a 1510 then add column g"

Then include the same question to each of the tabs of the worksheet?

I am trying to consolidate information from 10 pages to 1 but much of
the information is different, meaning the 1510 is not in all sheets but
does need to be included into the consolidation.

Maybe if someone knows a better way you can help?

Thanks!
Completely frusterated!


--
DBsWifeLB
------------------------------------------------------------------------
DBsWifeLB's Profile: http://www.excelforum.com/member.php...o&userid=10802
View this thread: http://www.excelforum.com/showthread...hreadid=522287