| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to move and renaming data within a workbook
Guys,
I have a sheet of data, with many lines, that I want to seperate out onto individual tabs within the same workbook, and to re-name those tabs. ie within the master sheet their will be data for Area1, Area2, Area3 etc and what I need is Sheet1 = Area1 - tab re-named Area1, Sheet2 = Area2 - tab re- named to Area2 and so on. Anybody know how to write the code to do this?? Many thanks for any help Kind Regards David -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move data within workbook | Excel Discussion (Misc queries) | |||
| automatically move cell data in 1 workbook to another workbook | Excel Worksheet Functions | |||
| Move some data to new workbook - my attempted macro is no good | Excel Programming | |||
| can I move data from workbook A to B using a conditional formula | Excel Worksheet Functions | |||
| Workbook renaming | Excel Programming | |||
Threaded Mode
