Click here to Skip to main content
15,867,929 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have two excel sheets, a Master and New Event List. I need to search the Last Name column of the "New Event" and search the "Master" workbook to ensure that they are already a member. If Last Name is found in Master workbook, do nothing, if Last Name is not found in Master workbook, write out the entire line of data in a 3rd Excel Sheet or Open a new tab with that information.

What I have tried:

Nothing. Just starting. I have not coded in many years. Not sure how to begin.
Posted
Updated 16-Jun-19 1:18am
v2

1 solution

Quote:
Not sure how to begin.
Get a good book on Excel and VBA. Learn the various Excel functions that can do data searches (e.g. VLOOKUP) etc.
 
Share this answer
 
Comments
Maciej Los 16-Jun-19 7:18am    
5ed!
Richard MacCutchan 16-Jun-19 8:21am    
Thanks. I always wonder when people say, "not sure how to begin", what they think we can do about that, other than make the obvious suggestion.
Maciej Los 16-Jun-19 9:41am    
Oh, yeah! I would like to say: "Don't ask how. Just make a first step! Otherwise, you'll reach nothing."
Richard MacCutchan 16-Jun-19 11:21am    
Good advice. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900