Writing a macro to capture information on one sheet and add these values to existing totals on another sheet

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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
The formatting changed on the post.
For clarification;
Cell F5 (on Production Sheet) needs to be moved to column G on the Tracking Sheet
Cell F3 moves to Column E on the Tracking Sheet
Cell A3 moves to Column D on the Tracking Sheet
 
Upvote 0

Forum statistics

Threads
1,223,157
Messages
6,170,420
Members
452,325
Latest member
BlahQz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top