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
|