ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display multiple data (https://www.excelbanter.com/excel-discussion-misc-queries/11173-display-multiple-data.html)

Morgan Juul

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


Ron de Bruin

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





All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com