Hi
Plz see the attachments
If column A of sheet1 matches with column B of sheet2 then copy column K data of sheet2 & paste it to column D of sheet1 & save the changes
I need the macro of the same & Thnx for the Great Help
Output after runing the macro is pasted in sheet3 plz have a look(Only for understanding pupose it is putted in sheet3)
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi MB,
Why don't you simply hide column A and E:J on your sheet 2 to get the same result? No VBA needed then.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Maybe something like this ?
I put the result in Sheet1 column E for checking.Please Login or Register to view this content.
To put the result in column D, remove the comment sign (')
Last edited by karmapala; 05-22-2020 at 11:06 AM.
Thnx Mumps & karmapala too... for providing the solution of this problem
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks