Hello Guys,
I am new to VBA and would love some help.
I need to find the duplicates and then paste them into the new column. After that I need to highlight the populated cells in the new column
I have attached the small table
Hello Guys,
I am new to VBA and would love some help.
I need to find the duplicates and then paste them into the new column. After that I need to highlight the populated cells in the new column
I have attached the small table
Last edited by HometownHero; 01-09-2020 at 12:07 PM. Reason: New Excel File
Can you attach a short EXCEL file with data and example of the final result you want.
- Battle without fear gives no glory - Just try
Thank you for the help, I attached below
See next code
Please Login or Register to view this content.
@PCI,
Good one PCI, however, you could do without the "Dic" and "Scripting Dictionary". i.e.;
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Yes it was the first idea but it's not used, instead is used Evaluate ... some clean up is missing, Thx Winon for the commentyou could do without the "Dic" and "Scripting Dictionary". i.e.;
Thank you both very much! I am trying to learn VBA and it is a real challenge for me!
Cheers!
You're welcome and Thx for the Rep ...
Glad we could help.
You're welcome and Thank You for the Rep...It is appreciated!
Regards.
Just for the fun of it...
Please Login or Register to view this content.
Please Login or Register to view this content.
red part, as per your blue part, just for you Tsjaart as I know how meticulous you are...
Last edited by sintek; 01-09-2020 at 05:52 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you for the help, I have one question. Instead of the cells being in a1, I need the formula to work if they were in cells S12:V19. How would I fix that code to make it work
It means it is covering 4 columns, 2 for source1 and 2 for source2?
If yes you want to compare what ever cells are in the first or second column.
The final display still in column D ?
Can you attach an update of your file ??
I have edited the post with the correct excel file
Please Login or Register to view this content.
Last edited by sintek; 01-09-2020 at 12:50 PM.
Thank you!
..............................................
Thanks.gif
Here we are
Please Login or Register to view this content.
For the fun see next code
Adjust Const to your next update ...!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks