If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 - |
Thread Tools | |
Display Modes | |
|
|