Hi,
I am looking for a macro that will do the things mentioned below
Match column B(all cell data) of book1.xlsx with sheet2 of column A(all cell data) of book2.xlsx & If it matches then copy paste the data of column C of book2.xlsx to column I of book1.xlsx & if not matches then put 3 in column I
vba code macro will be placed in a seperate file macro.xlsm & sheet name can be anything
Thnx Alot
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
U forgot to mentioned 3 if it doesn't matches Sir
Did not forget. If it does not match, it does not copy. If it does not copy, you know it did not match.
Ya it does not copy but we have to put 3 in column I of book1.xlsx
Please Login or Register to view this content.
Thnx Alot JLGWhiz Sir for helping me in solving this problem Sir
Have a Awesome Day Sir
You're welcome,Originally Posted by dumdumbum
regards, JLG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks