Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling information from master sheet to multiple sheets | New Users to Excel | |||
Data Base, copy information one sheet to another automatically | Excel Discussion (Misc queries) | |||
MOVE SPECIFIC INFORMATION TO ANOTHER SHEET | Excel Discussion (Misc queries) | |||
Formula for automatically entering information from a master sheet | Excel Discussion (Misc queries) | |||
copy subtotal information to new sheet | Excel Worksheet Functions |