Hello friends,
In our work, we have 100's of data's included in which we daily use cntrl + F again n again to search things. I wanted to make this easy...For Ex : searching a data without typing Cntrl + F or something like that..
Please help me guys...Thanksss
Hi
Post a sample data with your requirements explained in it
Regards..
Click *, if my suggestion helps you. Have a good day!!
Thanks for you quick reply.
I have attached a sample file in which we have to cntrl + F and find.
Normally we have around 1000+ data's (which are our customer names and not numbers). For Ex: I have to find Data - 863654934. So I have to type Cntrl + F and then paste this number.
I wanted to prepare a file which would automatically detect the copied data.
For Ex: From internet I have copied 863654934 to the clipboard, the excel should automatically detect the number and find for me.
Thank you
Hi Rau,
I'm unable to find your attached sheet.
Thanks,
Bonny Tycoon
**If I was able to help please do not forget to click the small star icon at the bottom left of my post **
Oops sorry...
this may not make things any easier for you, but try using a =match() function...i put this in C1, with the number you are looking for in D1. you could paste the value there.
=MATCH(D1,A1:A165,0)
the anwer it gives if the row the data is in
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
No that is not what am looking for. I will explain you further.
The excel file contains customer names. So normally we press cntrl + F and find the name and check the correspondent data. What i want is when i copy the customer name from other software to the clipboard, the excel should automatically find the customer and the correspondent data.
yes i understand what you want, not sure if wnat you want is possible though, i was attempting to give you an alternative way
In order to run a macro, you would need, as a minimum, to press a shortcut key combination. That macro could retrieve what's on the clipboard, and then search for it.
However, since you have to press a key combination anyway, it seems to me it might as well be Ctrl+F, and you can paste from the clipboard into the find what box.
Entia non sunt multiplicanda sine necessitate
Okay...thats true...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks