| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to move and renaming data within a workbook
See this page Ozzie
http://www.rondebruin.nl/copy5.htm You must use this example http://www.rondebruin.nl/copy5.htm#all -- Regards Ron de Bruin http://www.rondebruin.nl "Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:5bd325a636d6a@uwe... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to move and renaming data within a workbook
Thanks Ron for your speedy reponse, the attached link works perfectly, and
I'm now using it, one other thing though, is it possible to say; insert 4 lines on each new tab and then move range a1:c2 to d1, then delete columns a:c I don't want to put any reference to sheet names, as they will change depending upon the data extract. Thanks again for your help Ron, Regards David Ron de Bruin wrote: See this page Ozzie http://www.rondebruin.nl/copy5.htm You must use this example http://www.rondebruin.nl/copy5.htm#all Guys, [quoted text clipped - 12 lines] David -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to move and renaming data within a workbook
Hi
Try this Above this line WSNew.Columns.AutoFit you can add this two lines WSNew.Range("A1:C2").Copy WSNew.Range("D1") WSNew.Columns("A:C").Delete -- Regards Ron de Bruin http://www.rondebruin.nl "Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:5bd376cf6668a@uwe... Thanks Ron for your speedy reponse, the attached link works perfectly, and I'm now using it, one other thing though, is it possible to say; insert 4 lines on each new tab and then move range a1:c2 to d1, then delete columns a:c I don't want to put any reference to sheet names, as they will change depending upon the data extract. Thanks again for your help Ron, Regards David Ron de Bruin wrote: See this page Ozzie http://www.rondebruin.nl/copy5.htm You must use this example http://www.rondebruin.nl/copy5.htm#all Guys, [quoted text clipped - 12 lines] David -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to move and renaming data within a workbook
Oops
To insert the rows use WSNew.Range("A1:A4").EntireRow.Insert -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Try this Above this line WSNew.Columns.AutoFit you can add this two lines WSNew.Range("A1:C2").Copy WSNew.Range("D1") WSNew.Columns("A:C").Delete -- Regards Ron de Bruin http://www.rondebruin.nl "Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:5bd376cf6668a@uwe... Thanks Ron for your speedy reponse, the attached link works perfectly, and I'm now using it, one other thing though, is it possible to say; insert 4 lines on each new tab and then move range a1:c2 to d1, then delete columns a:c I don't want to put any reference to sheet names, as they will change depending upon the data extract. Thanks again for your help Ron, Regards David Ron de Bruin wrote: See this page Ozzie http://www.rondebruin.nl/copy5.htm You must use this example http://www.rondebruin.nl/copy5.htm#all Guys, [quoted text clipped - 12 lines] David -- Message posted via http://www.officekb.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba to move and renaming data within a workbook
Morning Ron
Cheers for the code, inserting the additional lines and deleting the columns works fines however the the pasting of the copied cells doesn't seem to work? any ideas. Cheers for your help, David Ron de Bruin wrote: Oops To insert the rows use WSNew.Range("A1:A4").EntireRow.Insert Hi [quoted text clipped - 38 lines] David -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200602/1 |
| Reply |
| 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 | |||
Hybrid Mode
