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) |
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) |