i've got this template from another post on here but cant figure out how to
add more collums to the database and make them show up in the search function
could anyone be so kind to assist me with this? would really apreciate it
data upload.xlsm
best regards
henrik
Pretty simple. Here is the macro and the modification you have to do:
That's it.
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
kinda a newb on this subjekt where do i go to add this information im on a very beginner lvl with this
I added some columns in your data sheet.
Then I used the code of p24leclec to fill the data.
Fill in the search Holder disk and see what's happening.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
doesnt seem to work for me. nothing shows up in search when i search for something in the added collums
Have you accepted (to allow) macro's?
In my version (excel 2007) it works fine.
i have 2013 and i believe so yes
You have to input your data you want to search in cell B2. Confirm with enter.Please Login or Register to view this content.
After that you can push the button search.
anyway to make collum c and d in database seachable?
This one is for a search in column C.
See the attached file.
If you fill in main you get the data that are available.
how is it you add a collum to the seach ?
1) Does the second file does what you expected?
2) I changed the VBA code.
it really does tyvm!
changeing the VBA code is done how?
What does tyvm means?
2) Alt + F11
Then you get in the VBA editor.
On the left side you see a window.
There you find "module1" In this one you find the VBA code.
@oeldere: I suspect "thank you very much"
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
How easy can that be (thank you very much).
Thanks for explaining it, TMShucks
found i and changed value to From C to F
now nothing works:/
changed to collum value from B to F and now nothing works
what have i dont wrong?
It's not easy to tell, without seeing your file.
Please post your excel file, without confidentional information.
dont have permission to do that it seems attach function isnt availble for me
does this help you?
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks