Quick question. Ive been trying to google the results but i cannot find the right way to solve my issue.
Basically, i have 2 Excel workbooks. Lets call them WB1 and WB2. WB1 is basically a concise version of WB2. They contain details of my clients such as names, address and contact.
What i need to do is to:
1. Compare the names in WB1 with WB2
2. Return a particular cell from WB2 into WB1.
Any ideas how i can go about doing this? Im stumped.
Quick question. Ive been trying to google the results but i cannot find the right way to solve my issue.
Basically, i have 2 Excel workbooks. Lets call them WB1 and WB2. WB1 is basically a concise version of WB2. They contain details of my clients such as names, address and contact.
What i need to do is to:
1. Compare the names in WB1 with WB2
2. Return a particular cell from WB2 into WB1.
Any ideas how i can go about doing this? Im stumped.
What are you trying to achieve? Being more specific would help a lot. Are you trying to look for a specific name from data contained in both workbooks and then return it in a field somewhere? I don't think you can do it between workbooks, unless you mean worksheets.
What are you trying to achieve? Being more specific would help a lot. Are you trying to look for a specific name from data contained in both workbooks and then return it in a field somewhere? I don't think you can do it between workbooks, unless you mean worksheets.
1. I have a modified client list in WB1. It does not contain the cellphone numbers of my clients.
2. I have the original client list in WB2, with all my clients' data. It contains cellphone numbers of my clients.
3. I want to use the names in WB1, compare with the list in WB2 and return the matching cellphone numbers from WB2 into WB1.
If i do it between worksheets, any ideas what would the formula be like?
1. I have a modified client list in WB1. It does not contain the cellphone numbers of my clients.
2. I have the original client list in WB2, with all my clients' data. It contains cellphone numbers of my clients.
3. I want to use the names in WB1, compare with the list in WB2 and return the matching cellphone numbers from WB2 into WB1.
If i do it between worksheets, any ideas what would the formula be like?
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Related Threads
?
?
?
?
?
Ask a question
Ask a question
Overclock.net
27.8M posts
541.2K members
Since 2004
A forum community dedicated to overclocking enthusiasts and testing the limits of computing. Come join the discussion about computing, builds, collections, displays, models, styles, scales, specifications, reviews, accessories, classifieds, and more!