Thank you but I should have been more specific. This code works for one table but I need this code to apply to the whole worksheet which has multiple tables - all tables have the same column layout and heading description. I have updated my sample attachment.
I am looking for the updated VBA code that will work for multiple tables within one sheet.
And thanks for incorporating the Approved Yes with date function into the code.
I should have added to the post....looks like it deleted my original question. See Original scenario below.
Scenario: I Have two columns with drop downs that each contain the selection "Disapproved". If column G is selected "Disapproved" I want column H same row to autoselect "Disapproved". I want it to work visa versa. If column H is selected "Disapproved" I want column G same row to auto select "Disapproved".
With that said in the future should the selection need to change to "Yes-Approved" it seems I should just be able to highlight and delete/clear the cells and select another option in the dropdown.
So I only need the "Disapproved" selections to be dependent on each other.
As stated above when the Approved Column is selected "Yes" the current date is entered into corresponding row in Column J as shown in the files code.
Bookmarks