Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a master sheet of several (12 maybe more) worksheets Saad Excel Discussion (Misc queries) 1 November 10th 09 12:54 PM
populating seperate worksheets from master deb Excel Discussion (Misc queries) 1 August 14th 08 07:25 PM
create chart with data from across seperate worksheets Diz Charts and Charting in Excel 3 December 23rd 07 04:00 PM
how do you create a daily diary using seperate worksheets? Doddie Excel Discussion (Misc queries) 0 March 14th 06 12:16 PM
create total from 4 seperate worksheets Harvey Excel Discussion (Misc queries) 2 February 16th 06 08:59 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"