Search for data

QT2006

New Member
Joined
Sep 4, 2006
Messages
10
I have made the spreadsheet alot simplier to those that saw my last post.

Now what I need to do (if its possible)

Search for some data and make all the searched data be put somewhere other than the sheet the data is on.

Ie.

Here is my spreadsheet

City Space Walking Distance dadsdsd asdfsdfsd

LON 100 5 dsf df
STL 232 6
NYC 434 34 df
dss rwr 34
sdw ewe 43
sds wewe 65
LON
dssds
NYC
LAX



So based on the above, if I need to search for all the LON and the corresponding info...ie- space, walking distance...blah

how would i do that...I know I could do a find search to highlight all the 'LON' but I want the information seperate...ie...maybe i am only interested in the LON requirements

Can you help
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

QT2006

New Member
Joined
Sep 4, 2006
Messages
10
Ok the info didnt come out how i wanted it to...but you can see what I mean..imagine the titles are city, walking space..and there is data underneath it
 

sweater_vests_rock

Well-known Member
Joined
Oct 8, 2004
Messages
1,657
qt2006.

seems like an autofilter would do what you need. you could use that to search on any column of info. you can also easily copy only the returned values to another sheet by simply selecting->copying->pasting.

to create an autofilter, highlight your header row, and goto Data->Filter->Autofilter.

cheers.ben.
 

QT2006

New Member
Joined
Sep 4, 2006
Messages
10
Thanks Ben

Will try it and let you know..

Oooh yea I just realised...how do you get a autofilter?
 

Forum statistics

Threads
1,141,019
Messages
5,703,760
Members
421,315
Latest member
awaisnazir139

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top