| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping and moving worksheets by name using VBA?
Hi all, Is it possible to group sheets ending with a certain name and move them to a new workbook in my documents named by the name i am grouping by? Lets say i have 20 sheets each named "**** Today" where **** is a variable, is it possible in VBA to group all the sheets with name ending in Today and move them to a new workbook in my documents and name the workbook "Today"? Hope you can help! Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=546346 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping on protected worksheets | Excel Worksheet Functions | |||
| Moving between worksheets | Excel Discussion (Misc queries) | |||
| separate worksheet into multiple worksheets by grouping | Excel Worksheet Functions | |||
| grouping hidden worksheets | Excel Discussion (Misc queries) | |||
| Data Grouping when Worksheets Protected | Excel Programming | |||
![Simon Lloyd[_741_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
