Hi Excel Forum,
Can you guys please help me out with my project. I have an excel file with 2 different columns filled with letter combinations which I need to update every now and then. I would like a code that will automatically fill in the codes not available in each list at the next columns.
Please see attached Sample Data to look how it will look like.
I really appreciate you guys helping me out. Looking forward in hearing from you guys soon!
try this:
Make sure columns C and D are empty before running themacro
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
YOu can use vlookup formula in Column C and D to get the data.
Thank you very much p24leclerc! This works perfectly!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks