Search and copy.. [Closed]

Report
Posts
2
Registration date
Wednesday January 20, 2016
Status
Member
Last seen
January 20, 2016
-
 Blocked Profile -
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 replies


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!
Posts
2
Registration date
Wednesday January 20, 2016
Status
Member
Last seen
January 20, 2016

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..

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?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!