Writing a macro to capture values from one sheet and add them to totals on another sheet out on the server.

[ghostbroker2]

Production Sheet : Dropbox - Production sheet (TEST).xlsm
Extrusion Tracking: Dropbox - Extrusion Tracking TEST.xlsx


Need the SCRAP totals from K3:L5 of the Production Sheet to be added to the existing totals in Column P of the Extrusion Tracking spreadsheet, into the corresponding row matching the Extruder Name from the dropdown menus in Production Sheet Cells I3:J5

The Extrusion Tracking spreadsheets pathway is as follows:
"\\RWCAD\Dashboards\Extrusion Tracking TEST.xlsx"

It is also worth mentioning that the Extrusion Tracking spreadsheet will most likely not be open when operators are submitting production information.

Still learning VBA, thanks for educating a brother.