If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA code to search each sheet for specific values

Thread starter Zimmerman
Start date Sep 30, 2011

Zimmerman

Well-known Member

Sep 30, 2011

Can somebody help me out with a VBA code that will search thru the 28 sheets in a workbook and if a value is found, then return that value to another sheet. I have a workbook that has 27 sheets that we use to cost out a project. and on the 28th sheet is a totals page. I would like to have say cell C2 look thru each tab and look at each value in cell A2 and B2. If they match the value in cell A2 and B2 in this totals tab then return the value of cell B3 from what it searched for. But there may be 10 values that match so I'd like to be able to have them all add up.

Thanks in advance
Windows XP
Excel 2003