Linking independent and dependent drop down costs to master budgets

[RookieBookie]

Hello,

As stated in my username, I am a rookie and in desperate need of help.

I am trying to deduct amounts put in cost cells from two different sheets/tabs.
I have five dependant drop down lists linked to five tables (rows k to s), and one independent (row u).

I would like the cost choices made in "Activity" to deduct from their related cells in Master Budget sheet.
I would like cost choices made in "Action Plan Specs" to deduct from their related cells in Action Plans Specs sheet.
So, the amount in cost to deduct from two cells in two sheets.

Any help would be sincerely appreciated as the ways I'm thinking will take for absolutely ever to do.

The link to the worksheet is below

To Upload.xlsx

1 file sent via WeTransfer, the simplest way to send your files around the world

we.tl

 

[Fluff]

Duplicate to: Linking independent and dependent drop down costs to master budgets

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.