Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
I have a worksheet with multiple columns. After the data has been sorted
(say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Hi JKR
See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Ron,
Thanks so much for your help. I tried this yesterday and it worked like a charm. "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Ron,
Thanks again for your help. The function produced 65 files. All of the files seem just fine, except that some of the files do not have an XLS extension (about 24 files). I cannot figure out why. Can you point me in the right direction to have all of the files created have the XLS extension or what to look for? "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Strange, send me the workbook private so I can test it for you
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Ron, Thanks again for your help. The function produced 65 files. All of the files seem just fine, except that some of the files do not have an XLS extension (about 24 files). I cannot figure out why. Can you point me in the right direction to have all of the files created have the XLS extension or what to look for? "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Hi Ron,
I had sent you an e-mail 10-25 with an attached Excel file that you could look at. Please let me know if you have received and if you have had a chance to look at it. Thanks! Jackie "Ron de Bruin" wrote: Strange, send me the workbook private so I can test it for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Ron, Thanks again for your help. The function produced 65 files. All of the files seem just fine, except that some of the files do not have an XLS extension (about 24 files). I cannot figure out why. Can you point me in the right direction to have all of the files created have the XLS extension or what to look for? "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Found it in my mail box (many mails to answer there)
Will look at it today or tomorrow -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Hi Ron, I had sent you an e-mail 10-25 with an attached Excel file that you could look at. Please let me know if you have received and if you have had a chance to look at it. Thanks! Jackie "Ron de Bruin" wrote: Strange, send me the workbook private so I can test it for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Ron, Thanks again for your help. The function produced 65 files. All of the files seem just fine, except that some of the files do not have an XLS extension (about 24 files). I cannot figure out why. Can you point me in the right direction to have all of the files created have the XLS extension or what to look for? "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create multiple new workbooks based on sort criteria
Hi JKR
I update the macro on my site to avoid problems with the extension. http://www.rondebruin.nl/copy5.htm#workbook Sometimes you must help Excel to think <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Found it in my mail box (many mails to answer there) Will look at it today or tomorrow -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Hi Ron, I had sent you an e-mail 10-25 with an attached Excel file that you could look at. Please let me know if you have received and if you have had a chance to look at it. Thanks! Jackie "Ron de Bruin" wrote: Strange, send me the workbook private so I can test it for you -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... Ron, Thanks again for your help. The function produced 65 files. All of the files seem just fine, except that some of the files do not have an XLS extension (about 24 files). I cannot figure out why. Can you point me in the right direction to have all of the files created have the XLS extension or what to look for? "Ron de Bruin" wrote: Hi JKR See http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JKR" wrote in message ... I have a worksheet with multiple columns. After the data has been sorted (say descending by column L - lets say column L is the customer name). Is there a macro that can be run that would automatically save a sheet named for each unique occurrence in customer and have just the rows for that customer, saving as many sheets as there are unique customer names? Thanks in advance for any help that you may be able to offer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create COUNTIF functions based on multiple criteria? | Excel Worksheet Functions | |||
Multiple sort criteria | Excel Discussion (Misc queries) | |||
Using VBA To Sort Multiple Criteria | Excel Discussion (Misc queries) | |||
How to create reports based on data residing in multiple workbooks | Excel Discussion (Misc queries) | |||
Create a list based on single shared criteria | Excel Worksheet Functions |