Hello,
I would like some help with a macro that searches a "database" which is located in a sheet from another sheet. I want people to choose which title you should look into using a rolling list and then enter a value and then press search. Then, the macro download the information from the "database"
See attached file.
Thanks in advance
Sincerely
Svanis
Last edited by Svanis75; 10-13-2010 at 05:28 AM.
Please find attached.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
No macro is needed, a standard INDEX/MATCH can look up the matching rows in realtime with the assistance of an added KEY column to your database.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
A macro isn't really necessary, AutoFilter would do the job.
If you want to use a macro then record a macro whilst filtering the data. This code can then be adapted for future use
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank´s to all off you. All the solotions works.
//Svanis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks