On the attached spreadsheet, I need to be able to enter info into the search box on the 'search tool' tab and have it pull the information from any of the columns on the main tab. Also need a "No Report Found" if nothing is found.
On the attached spreadsheet, I need to be able to enter info into the search box on the 'search tool' tab and have it pull the information from any of the columns on the main tab. Also need a "No Report Found" if nothing is found.
Is this a VBA query?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Not sure, I thought it was a search box program. I'm not sure how a VBA works compared to a search function, if I have posted in the wrong forum then I apologize and I can move it to the VBA forum if needed.
You have posted a macro-enabled workbook. There is a form with a form cont=rol (text box). This means it's a VBA query.
I am moving this to the correct section.
Thank you, i will attempt to ensure if there is a macro involved to ensure it is posted correctly.
Have a trial of the attached - I have placed your data in a 'structured table' (they are more suited to data handling).
For satisfactory searches it is best if all fields contain data (even if it is common and a repeat of the cell above/below).
With 'structured tables' do not extend them with blank rows - to add data just start typing in the row immediately under the table, as you move from the first cell the table will dynamically expand to intergrate the added data.
after typing in the 'keyword' textbox the 'GO' button will search for a 'string' or 'partial string' and put any found rows in the listbox for a final choice, then transfer to the blank table for viewing.
Notice the great reduction in file size as a result of removing unnecessary pre-formatting.
Last edited by torachan; 07-10-2023 at 08:06 AM.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Sorry for the delay in getting back, I had a family emergency to deal with. But yes simultaneously, for example if I type in safety helmets, then every infraction for this would populate on the search tab.
I have uploaded version 2 to post#7 (I noted your post #8 - "safety helmets") so have extended the search range to cover that field.
I am not sure how this works. The search tab looks similar to the main but when I enter data into the first cell (A2) nothing happens. The rest of the line does not populate. Am I missing something here?
Big yellow button "Show Search Form" - press it and you have a search form - type in your search keyword - press go - listbox populates with all rows containing keyword - select appropriate row - sheet table then populates.
Sorry but I don't have a big yellow button, attached is the screen shot of what opens from the file download you sent
Your screen is obviously smaller than mine - bring column 'J' into view.
Attachment 835971
Thank you, that works but not what I'm looking forward. I need the document to list the entire compliment of what we search for. Example: if we search for "safety helmets", we need to see all infractions for this and then be able to download them into a spreadsheet for forwarding to individual dept. mgrs., I am not dealing with tech savvy individuals so the simplest method would be to have them populate on a spreadsheet that can then be manipulated and saved.
try the attached - is that any better ???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks