I have 3 Sheets: #1 = Closeouts, #2 = Annual Incentives; #3 - Incentive Distribution
When a closeout is completed, data is entered on Sheet#3 - Inc. Dist. I have a Data Mesh to pull the data from the # 3 to populate Info on #2 Ann Inc. I am trying to get a formula or function that will do the following: When an entry is added to #1 Closeouts, add just 2 pieces of info to #2 Ann Inc
This diagram is Sheet #2 - It only contains data created at this point. Moving forward I need Job No and Project to populate when the same data is added to sheet #1 Closeouts
The formula to add this will eliminate having to do a manual entry on Sheet #2 when an entry is made on Sheet #1. Then it all works!
Hope this makes sense! I've confused myself!