ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Help!!! (https://www.excelbanter.com/excel-worksheet-functions/49363-excel-help.html)

Alison

Excel Help!!!
 

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

Sandy Mann

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





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

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