ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiple page if statement (https://www.excelbanter.com/excel-discussion-misc-queries/77206-multiple-page-if-statement.html)

DBsWifeLB

multiple page if statement
 

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!:confused:


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



All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com