• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Start typing to select comparitive list

Linda Hunter

Linda Hunter

New Member
Morning, I have 2 excel tabs, 'List' to 'cut and paste' from to the other list 'Analysis' which is mostly self-populated.

I have attached both lists.

in 'Analysis', we need to be able to start typing into column 'Unit rate Description' and have only a list containing what is being typed, show up i.e "cab" will bring up everything to do with "cable"; or "con" will bring up everything to do with "conduits". Once an item is selected, the 'Unit' measure will also auto-populate.

Per 'Punchlist #' and 'PL Description' there may be several 'Unit rate Descriptions' that apply (see tab 'Analysis'), so I know I'll need to set up the spreadsheet a bit differently to what is being shown.

Please note the lists are not complete and are just a sample. The 'list' tab is actually about 4 pages long.

Hope this makes sense. Please let me know if you require any further information.
 

Attachments

Hi:

As per my understanding you want to filter the list tab using wild cards and paste that information into the Analysis tab, If yes let me know , this can be achieved using a simple macro.

Thanks
 
Well, yes, I think. Would you mind very much showing me an example. I've uploaded a spreadsheet from another post on Chandoo.org which uses the Search, Index, Match and Aggregate to 'filter' for limiting the list. This is the kind of thing I was looking at, but wondered if we can be a bit more sophisticated with it???
 

Attachments

thanks. The concept is fantastic and will work really well although when typing in another search item nothing happens. I'm not very good with VBA so not really sure to solve this. Basically, the new tab for Search is defaulting and nothing I type in changes it.
 
Hi:

Its working fine at my end . You will have to enable the macro before using the file , once you type in the search criteria in the colored cell, just click on search button it will retrieve the data for you.

Please follow the following link to learn how to enable the macros, its fairly easy to enable a macro.

http://www.exceltrick.com/how_to/enable-macros-in-excel/

Thanks
 
thanks Nebu. I've passed the spreadsheet onto the recipient, and we attached the fully populated 'List'. When searching it would only pull back the first name or (3 letters) of column C. Is there something I can put into the VBA so it will search for anything in a line item of column C please?
 
You must log in or register to reply here.
Back
Top