On Sep 25, 9:29*am, Johnnyboy5 wrote:
Hi

I have a workbook with 13 sheets in it. *(months and a final totals
sheet)

I need a macro to search all the sheets and find different categories
of people who have referred to our service over the months. * E.G

SW
OT
PT
GP
NURSE

Etc….

I would then like the macro to insert the results in a final total
sheet with lots of other totalled data for the year.

Hope this is clear – ish

Johnnyboy

Should be easy enough to do using Find within workbook instead of
sheet. Record a macro while doing. If all else fails,
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."