Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Alison Wrote: I am trying to make a database type spreadsheet on excel. I have 5 cells which are search fields. when i type in a number or word in one or more of these cells i would like the info from shpreadsheet two to apprear in rows below... possible???? I need this done by Monday!!!!!! Can nobody help me on this one?!?!?! -- Alison |
#2
![]() |
|||
|
|||
![]()
Alison,
I think perhaps you may have to give more information. I mean you say you have I have 5 cells which are search fields. when i type in a number or word in one or more of these cells i would like the info from shpreadsheet two to apprear in rows below... what information do you want returned? whole rows? part rows? cells? Perhaps either Autofilter or Advanced Filters could do what you are looking for. -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Alison" wrote in message ... Alison Wrote: I am trying to make a database type spreadsheet on excel. I have 5 cells which are search fields. when i type in a number or word in one or more of these cells i would like the info from shpreadsheet two to apprear in rows below... possible???? I need this done by Monday!!!!!! Can nobody help me on this one?!?!?! -- Alison |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |