Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a number and data appears from another sheet
I have a document that lists volunteers and their personal info (name,
email, phone etc.) with the Week number (1-5) of the Sunday when they help out. Some volunteers are in age group K-2nd and the others are in 3rd-5th. What I am doing at the moment is sorting by Week number and then filtering by week number (e.g. 2 for the second Sunday of the month). I then copy that information to another sheet in the same workbook. What I would like to do is just type a week number e.g. 2 in A1 of "This Week" sheet and then somehow *magically* have all the people from both K-2nd and 3rd-5th listed in their separate sheets for that weekend (2nd) end up on the This Week sheet so I can see who is coming/supposed to be coming. That way, all I need to do is edit the K-2nd and 3rd-5th Worksheets and not have to work with/edit data from the This Week sheet. I have *no* idea how to do this as my knowledge of Excel is simple at best with easy =IF statements. Can someone in the know help me out please? Thanks very much. (Using Excel 2007 but will need it to be 2003 compatible) |
#2
Posted to microsoft.public.excel, microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a number and data appears from another sheet
I don't quite follow all your descriptions, but if you would like to
send me a small version of your file (.xls format please), then I'll have a look at it for you. Send to: pashurst <at auditel.net Change the obvious. Pete On Dec 12, 4:24 am, "(c)(R)" wrote: I have a document that lists volunteers and their personal info (name, email, phone etc.) with the Week number (1-5) of the Sunday when they help out. Some volunteers are in age group K-2nd and the others are in 3rd-5th. What I am doing at the moment is sorting by Week number and then filtering by week number (e.g. 2 for the second Sunday of the month). I then copy that information to another sheet in the same workbook. What I would like to do is just type a week number e.g. 2 in A1 of "This Week" sheet and then somehow *magically* have all the people from both K-2nd and 3rd-5th listed in their separate sheets for that weekend (2nd) end up on the This Week sheet so I can see who is coming/supposed to be coming. That way, all I need to do is edit the K-2nd and 3rd-5th Worksheets and not have to work with/edit data from the This Week sheet. I have *no* idea how to do this as my knowledge of Excel is simple at best with easy =IF statements. Can someone in the know help me out please? Thanks very much. (Using Excel 2007 but will need it to be 2003 compatible) |
#3
Posted to microsoft.public.excel, microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a number and data appears from another sheet
I've received your file, worked on it, and sent it back to you.
Hope this helps. Pete On Dec 12, 9:22 am, Pete_UK wrote: I don't quite follow all your descriptions, but if you would like to send me a small version of your file (.xls format please), then I'll have a look at it for you. Send to: pashurst <at auditel.net Change the obvious. Pete On Dec 12, 4:24 am, "(c)(R)" wrote: I have a document that lists volunteers and their personal info (name, email, phone etc.) with the Week number (1-5) of the Sunday when they help out. Some volunteers are in age group K-2nd and the others are in 3rd-5th. What I am doing at the moment is sorting by Week number and then filtering by week number (e.g. 2 for the second Sunday of the month). I then copy that information to another sheet in the same workbook. What I would like to do is just type a week number e.g. 2 in A1 of "This Week" sheet and then somehow *magically* have all the people from both K-2nd and 3rd-5th listed in their separate sheets for that weekend (2nd) end up on the This Week sheet so I can see who is coming/supposed to be coming. That way, all I need to do is edit the K-2nd and 3rd-5th Worksheets and not have to work with/edit data from the This Week sheet. I have *no* idea how to do this as my knowledge of Excel is simple at best with easy =IF statements. Can someone in the know help me out please? Thanks very much. (Using Excel 2007 but will need it to be 2003 compatible)- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The number I type in a cell, e.g. 500, appears at 0.5 - why? | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
When I type in 100 a 1 appears, 10000 and 100 appear | Excel Discussion (Misc queries) | |||
count the number of times data appears on the same row from two c. | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |