I have a workbook that I use for building estimating. It has a number of sheets and the main estimating sheet is called "Estimate". I then have continuation sheets (the first is named "Continuation Pg" and subsequent ones (added as needed) are called "Continuation(2)" "Continuation(3)", etc.

I need to search the "Estimate" and all "Continuation" sheets for a text string, e.g., "Total Building Damages:" and when it is found, it will be in Col A of one of those sheets. I then need to display the value in Col F of that row in another sheet (named "Report"), in E21. Further, I need to display the value in Col G of the "Estimate" sheet (same row) in G21 of the "Report" worksheet. And so on for other values.


Since there should be only one occurrence of this text string in the workbook, it would be OK to search the entire workbook for this string.


Can anyone help me get started? I'm not all that familiar with VBA, but I'm getting lots of good info from the newsgroup and have bought a couple of books.
Hopefully, I'll start to pick it up.

TIA,

Jim