Connecting Data Between Sheets for Budget Tracking

Copper Contributor

Hello, 

 

I am looking to connect a sheet to another in order to quickly track budget updates. I use one large spreadsheet to track the status of the program budget, as well as the status of individual invoices I am entering. I would like to figure out a way to connect the processing spreadsheet to the budget spreadsheet by entering the budget allocation term in the processing spreadsheet and having it populate the correct areas in the budget spreadsheet. Currently it is a lot of back and forth between both when the information is the same. Is this possible? 

0 Replies