Previous Topic Next Topic

Search and copy..

Closed
ja981m Posts 2 Registration date Wednesday January 20, 2016 Status Member Last seen January 20, 2016 - Jan 20, 2016 at 12:04 PM
 Blocked Profile - Jan 20, 2016 at 08:09 PM
I have two Work Books open and I have filters on both WBs.. Let's say I have filters for Name, Birth Date, Address, and Phone# for both WBs. Is it possible for a macro to search WB2 each time I copy a cell from either of the filters in WB1.

Example:
I copied a name from WB1 and the macro will search the name in WB2.


I'm trying to simplify WB2 since it's a mess, hence I'm creating WB1. But I have like 300k of names to go to and I need something to help me..


Thanks in advance.

Kind ragards,
ja981m

2 responses

Answer 1 / 2
Blocked Profile
Jan 20, 2016 at 05:57 PM
Want you are attempting is OLE. Object linking and embedding. Yes you can link the two together. Make WB1, and insert a WB2 object, but link it, do not copy and insert it. You must link so changes to WB2 will be reflected in WB1.

I hope this give you some direction!
0
ja981m Posts 2 Registration date Wednesday January 20, 2016 Status Member Last seen January 20, 2016
Jan 20, 2016 at 07:29 PM
Sorry about this.. I forgot a key information on what I want to happen..

With the given example above, in WB1 I'm missing the birthdates of the people in WB1, so I usually search WB2 with the matching name and address and get their birthdate..

Sorry again, I was a bit sleepy and kinda in a hurry..

Thanks in advance..
0
Answer 2 / 2
Blocked Profile
Jan 20, 2016 at 08:09 PM
What did you learn about OLE? Did I forget to mention that we are volunteers, and if I were to produce this turnkey it wouldn't be free?
0

Similar discussions

Search in conversations on Messenger not possible anymore
GentseGast -
kiransaini88 -

3 responses