PDA

View Full Version : Need help creating Search box assign macro to search from various worksheet!



viagrastim
01-03-2008, 12:38 PM
Hi Everyone,
PLEASE HELP!!!!!!
First please excuse my english if it bad... Here is my story...
I have an excel workbook to keep all bills and notices etc....I separate them in many different worksheet so it's easy for me to tell which is which, but now it come to the point that I have so many of them and could not go to sheet by sheet to look for it. Here is what I would like to do if someone can help. I would like to create a Search box in a new worksheet and assign macro to search for entry in many different worksheet if entries found copy that entry on to same worksheet that I have created search box in. Can you someone come up with the code and show me how to insert it into my work that will be great.

Thank you in advance for the help!

Bob Phillips
01-03-2008, 01:35 PM
Jan Karel Pieterse has a free utility at http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.asp

viagrastim
01-03-2008, 04:23 PM
thank you xld that's work beautiful....

thank a lot!!!!!!!