find

[Johnnyboy5]

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

 

[Don Guillett Excel MVP]

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."