ghostbroker2
Board Regular
- Joined
- Feb 13, 2017
- Messages
- 58
I'm attempting to write a macro that will capture the values on the production sheet and disperse them onto the Rewinder Tracking sheet in the appropriate column/row.
Capture from Production Sheet Cell Add to Existing totals on Tracking Sheet in Column
F5 G
F3 E
A3 D
Cell K1 (on Production Sheet) contains Employee numbers. I need the captured information from the Production Sheet to be dispersed into the row that has the same employee number on the Tracking Sheet. I'm still new to VBA, so I need to see this one done once before I can attempt writing it.
My intentions are to create a button on the Production Sheet called "Submit" that will execute these "Capture and Add" steps. Then I'll write a macro to clean the form (Production Sheet) and stack it after the "Capture and Add" steps.
The dropbox link to the spreadsheets follow;
Dropbox - Rewinder Tracking
Capture from Production Sheet Cell Add to Existing totals on Tracking Sheet in Column
F5 G
F3 E
A3 D
Cell K1 (on Production Sheet) contains Employee numbers. I need the captured information from the Production Sheet to be dispersed into the row that has the same employee number on the Tracking Sheet. I'm still new to VBA, so I need to see this one done once before I can attempt writing it.
My intentions are to create a button on the Production Sheet called "Submit" that will execute these "Capture and Add" steps. Then I'll write a macro to clean the form (Production Sheet) and stack it after the "Capture and Add" steps.
The dropbox link to the spreadsheets follow;
Dropbox - Rewinder Tracking