How do I copy specific information from a master sheet?
 

I have a master list of clients, birthdates and representatives and other
information.

I want Excel to automatically generate separate worksheets based on the
information found in the master list.

For example:
A B C D E F
Joan Smith Jan 21 NDE other info other info
John Jones Dec 1 MS other info other info
Sue Adams Oct 12 SCD other info other info

And so on. I have about 300 people in total.

What forumula do I use to automatically extrapolate to another worksheet
only Colums A, B, C, D and F for all clients with DOB (column C) in Jan. And
then all clients with DOB in Feb, Mar, Apr etc. - each month to a separate
worksheet?


Thanks,
Freda

How do I copy specific information from a master sheet?
 

Consider a helper column and the use of AutoFilter. Say we have a Master
worksheet wil column headers in row #1 and 12 additional (monthly) worksheets.

In cell A1 of Sheet1 enter:

=Master!A1 copy this both across & down

Sheet1 will be a duplicate of Master. Repeat this for Sheets 2 thru 12.

Back on Sheet!, put a label in G1 and in G2 enter:

=IF(LEFT(C2,3)="Jan",1,0) and copy down

Turn on AutoFilter on G1 and pick only 1's

Do similar for Sheets2 thru 12.

--
Gary''s Student - gsnu200795


"PFAA" wrote:

I have a master list of clients, birthdates and representatives and other
information.

I want Excel to automatically generate separate worksheets based on the
information found in the master list.

For example:
A B C D E F
Joan Smith Jan 21 NDE other info other info
John Jones Dec 1 MS other info other info
Sue Adams Oct 12 SCD other info other info

And so on. I have about 300 people in total.

What forumula do I use to automatically extrapolate to another worksheet
only Colums A, B, C, D and F for all clients with DOB (column C) in Jan. And
then all clients with DOB in Feb, Mar, Apr etc. - each month to a separate
worksheet?


Thanks,
Freda