Hi Experts
I need your expertise to help me in this.
Based on the cell value (Column D), I would need a code that matches the value in Column D of Master Sheet with Column A in the second tab (EXEMPT) to delete the rows from master sheet and keep the records a new worksheet.
The code should also match the Column D of Master Sheet with Column A of third tab (NATCON) and highlight them.
Is this doable please? I have attached the sample data.
Thanks
Jared
Hi jared
One way with filter...
Not sure if you are aware...You have "WAIPUNA" as deletion and highlight value?
Please Login or Register to view this content.
What does this mean...
If it means to place the deleted data to a new sheet then make use of this instead of above...and keep the records a new worksheet.
Please Login or Register to view this content.
Last edited by sintek; 11-06-2020 at 02:39 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!!!
Awesome, worked like a magic.
Thank you so much.
..........................
THANKS.gif
Hi Sintek
Sorry to be a pain, just had another requirement added to the last one and need your help if you could please.
in the attached sample data, now
We need to match between Column C in Sheet 1 with "CUSTOMER GROUP", Column D in Sheet 1 with "CUSTOMER NUMBER" and Column D in Sheet 1 with "CUSTOMER DESCRIPTION" and delete the matches and place them to the "DELETED" Sheet.
"NATCON" should be matched with Column C in Sheet 1 and highlighted the duplicates.
Is it doable? "Customer Description" should not be 100% match, like if most of the description matches it should pick and place them to DELETED sheet.
Thank you heaps for your help
Hi Jared
Have a project deadline...No time at the moment...If no one else has provided a solution, will check it out when I get a moment...
Thanks you Sir, much appreciated.
No one has provided a solution yet, if you could please have a chance to look at when you can please. thanks.
Please explain in detail step by step what you are wanting to achieve...Also supply a sample file with expected outcome and explain how you achieved this...
Thanks, i have updated the sample data. All the highlighted rows should be deleted from Sheet 1 and be placed into the DELETED worksheet,
We need to match
Sheet 1 Column C = Customer Group
Sheet 1 Column D = Customer Number and
Sheet 1 Column E = Customer Description (Should pick the most match)
Sheet 1 Column C = NATCON to highlight the cells in Column C.
You have previously given me the code as below which was perfect but need a revised one for this now please, thank you
Please Login or Register to view this content.
Last edited by jaredli; 11-19-2020 at 08:44 PM.
Had a couple minutes free...Can only check back next week again...
By the way...take Note...Please Login or Register to view this content.
Your post above does not comply with Rule # 2
2. Programming code must be enclosed in code tags to improve readability. (A, Z)
So...Edit your post...Highlight the code and press the # buttonPlease Login or Register to view this content.
Sorry My bad, i have corrected this now.
This code didn't work and giving me the error that i have attached.
Sample upload had different sheet numbers...
This works...
Awesome, you're a gem. Thanks and God bless you!
My pleasure...
Thank you. God bless you too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks