ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   need a way to create seperate worksheets from a master (https://www.excelbanter.com/excel-programming/362195-need-way-create-seperate-worksheets-master.html)

sunkat

need a way to create seperate worksheets from a master
 
I'm a volunteer who needs to take a master worksheet and then subset
into individual groups. To keep maintance low I'd like a way to add
the new people to the master and then let the program sort it into the
subsets. I can do some minor coding but not use to coding in excel.

thanks in advance


Bernie Deitrick

need a way to create seperate worksheets from a master
 
sunkat,

Use data filters on your master worksheet. As long as you have the 'subset' data associated with
the people being added to the master list, data filters are the lowest maintenance method available.

HTH,
Bernie
MS Excel MVP


"sunkat" wrote in message
ups.com...
I'm a volunteer who needs to take a master worksheet and then subset
into individual groups. To keep maintance low I'd like a way to add
the new people to the master and then let the program sort it into the
subsets. I can do some minor coding but not use to coding in excel.

thanks in advance





All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com