Looking up info

[Larry Hines]

Hello.
I'm trying to create something that I can type in certain words and it will
search multiple sheets and give me the data that I need.

What is happening is that we some times start a new project and someone will
say it is just like one we did for someone else. Only problem is they can
never remember the job number. They can only remember the city or some other
little bit of information.

I have started putting in this information in excel but before I go to far
with it, I what to know how I am going to retrieve the data that I'm after.

Here is what I have so far
Number Name Size Type 1 Type 2 City State
2005-KM-01 Sleep Lab II 33' x 62' Modular Office Clackamas Oregon


What I what to be able to do is enter in 1 or more of the information that I
know, then have the results show up in a list in the form above.

Anybody know what formula or a something that will get this done?
Thanks in advance for any help.

 

[Larry Hines]

Boy that got messed up. See if this one is better

Here is what I have so far
Number Name Size Type 1 Type 2
City State
2005-KM-01 Sleep Lab II 33' x 62' Modular Office Clackamas
Oregon

 

[Dave Peterson]

If you're using xl2002+, you might find that edit|Find is sufficient. You can
search through the workbook and see a list of all the locations where your text
to find was found.

If you're using xl2k (or prior), you could use Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/

(In fact, Jan Karel's program will work with xl2002+, too.)

 

[Dave Peterson]

First, this is a text only newsgroup. Many people will ignore posts that
include attachments--even pictures. So you'll be better off stating your
requirements in plain text.

But it kind of looks like you could apply data|Filter|autofilter to each sheet.
Filter on your criteria and copy the visible rows to the results worksheet.

Attached is what I am trying to do. Can anyone point me in a direction to
get this done. Or can this be done using Excel 2000?

[Image]