Hello, I have one file that contains the forecast analysis for the coming quarter for all functions, I want a macro that will update with Master Budget file based on the budgeted item and the function, below is my example , I want a macro to update Workbook 2 values from Workbook 1 based on the budget item name and the function, so in the below example, communication cost for sales in Workbook 2 will be 150000, and so on
Thanks
Workbook 1,Tab X
<tbody>
</tbody>
Workbook 2, Tab x
<tbody>
</tbody>
Thanks
Workbook 1,Tab X
Budget Item | Function | Value |
Communication Cost | Sales | 150000 |
<tbody>
</tbody>
Workbook 2, Tab x
Budget Item | Function | Value |
Communication Cost | Sales | |
Communication Cost | HR |
<tbody>
</tbody>