| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find sheets with by part of name
I have a workbook that includes many sheets named "TT####" or ST####.
Also two summary sheets named TTall and STall. Im working a a macro to find all the sheets beginning with TT or ST then copy data from the sheets and paste that data in the respective "__All" sheet. I can do all the copy and paste offsetting etc but cannot figure out how to search through the sheet names for partial names and work that into a for each statement. I kick in the right direction would be helpful |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop several sheets - part 2 - dave | Excel Programming | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| Renaming sheets with part of original name | Excel Worksheet Functions | |||
| Macro for part of W/book sheets | Excel Discussion (Misc queries) | |||
| COUNT over several sheets...Part 2! | Excel Discussion (Misc queries) | |||
Threaded Mode
