Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Move Sheets
Pretty new to the VBA gig, so thanks in advance to anyone who offers up
help... I'm needing to record a macro for the following scenario: 3 - 5 workbooks, Same name, using numeric ordering I want to search for a specific worksheet in each workbook, and if it exists, move that sheet to a new workbook If the sheet I'm searching for isn't contained, let's say in wkbk 4, then just skip it and move on to wkbk 5. I think I have the moving the sheet part down ok, it's just the searching for, moving if present, and just moving on if it's not present..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to Move Sheets and save | Excel Discussion (Misc queries) | |||
Cannot Move or Copy Sheets | Excel Discussion (Misc queries) | |||
Use Tab key to move between tab sheets | Excel Worksheet Functions | |||
How do I move between sheets in a workbook? | Excel Programming |