VBA to help carry over relevant data from one table to another based on a project name?

[alexgeorge]

Excel 2010
Windows Vista

I have a project budget file consisting of a summary worksheet for all projects and separate project worksheets. One finance person enters budget allocations to and between the different projects on the summary worksheet (Budget Allocation Table), and project owners enter spends for their project on their specific project worksheet (Project ___ Budget Table). The Budget Allocation Table will be password protected and only finance will make edits.

I am trying to find a way to carry over data from the master 'Budget Allocation Table' to the individual 'Project ___ Budget Tables' for any line item that affects that specific Project Budget.

Assumptions: Budget allocation table will be managed by one person in finance and will be password protected Individual project budget sheets will each be on their own tab. All entries made ONLY in the budget allocation table. Project budget tables update automatically Individual project budget sheets need to 'scan' the budget allocation table and 'pick up' / 'repeat' any budget amount and note that applies to their budget. Macros/VBA are OK (although I am at them), file already has macros and is a .xlsm file type.

I've tried searching these forums, Excel help and on the web, but I'm mostly finding Vlookup type suggestions. I'm sure if I knew the 'name' of the feature that would work here, I would be well on my way to a solution.

Thank you in advance.
Alex

 

[alexgeorge]

There is a (non material) typo in my screen shots above. The line items showing a move in budget from Project A to Project B, should reference the same amount (both 250). Again, this has no bearing on my question, but might confuse some people as to why those amounts wouldn't be equal.