Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
Is there anyway I can use information on an excel worksheet to create
multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
Yes and Yes. What is a "naming sequence" and to what do you want it
assigned? HTH Otto "Poorvi" wrote in message ... Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
See
http://www.rondebruin.nl/copy5.htm#workbook -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Poorvi" wrote in message ... Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
I want to name each file after each cost center. So what I mean is if I have
data subtotalled by Cost center as follows: Cost Center Asset No. Asset Value Tag No. etc. Can I create one workbook for each cost center, named after the cost center. "Otto Moehrbach" wrote: Yes and Yes. What is a "naming sequence" and to what do you want it assigned? HTH Otto "Poorvi" wrote in message ... Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
Can I assume that you want a new file created and named for each entry in
Column A? Otto "Poorvi" wrote in message ... I want to name each file after each cost center. So what I mean is if I have data subtotalled by Cost center as follows: Cost Center Asset No. Asset Value Tag No. etc. Can I create one workbook for each cost center, named after the cost center. "Otto Moehrbach" wrote: Yes and Yes. What is a "naming sequence" and to what do you want it assigned? HTH Otto "Poorvi" wrote in message ... Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating multiple workbooks
This macro will do what you want. I chose "C:\The Folder" as the path.
Otto Sub CreateWorkbooks() Dim ThePath As String Dim rColA As Range Dim i As Range Application.ScreenUpdating = False ThePath = "C:\The Folder\" Set rColA = Range("A2", Range("A" & Rows.Count).End(xlUp)) For Each i In rColA Workbooks.Add ActiveWorkbook.SaveAs Filename:=ThePath & i.Value & ".xls" ActiveWorkbook.Close Next i Application.ScreenUpdating = True End Sub "Poorvi" wrote in message ... I want to name each file after each cost center. So what I mean is if I have data subtotalled by Cost center as follows: Cost Center Asset No. Asset Value Tag No. etc. Can I create one workbook for each cost center, named after the cost center. "Otto Moehrbach" wrote: Yes and Yes. What is a "naming sequence" and to what do you want it assigned? HTH Otto "Poorvi" wrote in message ... Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
creating multiple sheets, then individualized workbooks for each sheet | Excel Discussion (Misc queries) | |||
Need Help Creating a Macro Multiple Workbooks to One | Excel Worksheet Functions | |||
Creating a single workbook from multiple workbooks | Excel Discussion (Misc queries) | |||
Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) |