Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - delete the remainder of the text in the cell after my Find | Excel Programming | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming |