VBA selected drop down list does not update when source changes

dm10

New Member
Joined
Apr 7, 2021
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Hi! First time poster;)

I have a two-tab budget. First tab is “Monthly Budget”, the second is “Spending Tracker”. Every time I add an expense in the “Spending Tracker”, it updates the “Monthly Budget”. I do this by selecting a category from the drop down list on the “Spending Tracker”. I want to be able to change my categories on the “Monthly Budget” at any time and have the drop down list automatically updated – INCLUDING anything that has already been entered/inputted in the "Spending Tracker".

My problem is that if I have already inputted an expense on the “Spending Tracker” eg: Mortgage/Rent $1000 (in Column B) and then I change the category name on the “Monthly Budget” to just say Mortgage, my "Spending Tracker" doesn’t update or recognize the new name. The $1000 I previously entered does not get added to my “Monthly Budget” (see Actual "0.00" in yellow).

I am completely new to VBA but I know I need macros to enable my drop down list to automatically update when a category changes.

FYI My source for the drop down list on the "Spending Tracker" (Column G) has a CONCATENATE formula:
=CONCATENATE('Monthly Budget'!A2:B2," - ",'Monthly Budget'!A3:B3) to automatically change when I update the categories on the "Monthly Budget". So my source list updates, but the inputted drop down list (Column B) does not change.

What I want - anytime I alter a category name on “Monthly Budget” it automatically adjusts the “Spending Tracker” drop down list so that all of the calculations remain intact.

Any help with VBA code for this would be amazing! I’m on Microsoft 365 / Mac 10.15.7. Please let me know if I'm unclear on anything haha! Thank you!
 

Attachments

  • Monthly Budget.png
    Monthly Budget.png
    94.2 KB · Views: 4
  • Spending Tracker.png
    Spending Tracker.png
    119.1 KB · Views: 4

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,130,330
Messages
5,641,547
Members
417,220
Latest member
lam150498

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top