Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display multiple data
Hi!
I work as a paramedic, and one of my many task is to register all our activities. I use a excel sheet to collect all data.As we are many people working there, this must be simple.We put all information for one year in one page, may be 4-500 items, each with 25-35 data. No my problem: I need a way to find all info for one month or employed,and create a new list with these . My dream: I write employed number 245 in cell B6, and the all his data displayes underneath.... (excuse my bad english...) |
#2
|
|||
|
|||
Hi Morgan
If you install my Filter Add-in it is very simple to filter in place or copy all records from a certain month to a new sheet/workbook. Or all records with a employe number. Try it http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Morgan Juul" <Morgan wrote in message ... Hi! I work as a paramedic, and one of my many task is to register all our activities. I use a excel sheet to collect all data.As we are many people working there, this must be simple.We put all information for one year in one page, may be 4-500 items, each with 25-35 data. No my problem: I need a way to find all info for one month or employed,and create a new list with these . My dream: I write employed number 245 in cell B6, and the all his data displayes underneath.... (excuse my bad english...) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple data files for versioning purposes. | Excel Discussion (Misc queries) | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |