Writing a macro to capture values on one spreadsheet and add them to totals on another

[ghostbroker2]

Production Sheet dropbox link:
https://www.dropbox.com/s/vi2zpdo86e...T%29.xlsm?dl=0
Extrusion Tracking Dropbox link:
https://www.dropbox.com/s/5rn7wcsy62...TEST.xlsx?dl=0
On the Production Sheet, cells K3 through K5 will contain scrap values. Cells I3 through I5 contain operators names in drop down menus.
I need totals from K3:K5 combined with values in column P on the Extrusion Tracking sheet. I need the total to go to the row with the corresponding name from the Production Sheet cells I3:I5.
The Extrusion tracking spreadsheet lives out on our server and is usually not open. The pathway is:
"\\RWCAD\Dashboards\Extrusion Tracking TEST.xlxs"

I'm still new to VBA and don't know how to pull this one off.

Here's what I tried, but not working.

Please Login or Register  to view this content.

[xladept]

Well - I've shortened the code - but, what isn't working?

Please Login or Register  to view this content.

[xladept]

BTW:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[ghostbroker2]

It seems to be successful in capturing the value in K3 and moving the total to the appropriate place.
Is there a way to expand this functionality to cells K:4 and K:5, if there is a value there, and an Operator name in I:4 and/or I:5?

[xladept]

You should be getting the sum of K3-K5 if you're getting one you should get them all

[ghostbroker2]

I don't think the sum is where we want to go...
As each of those cells (k3-k5) need to have their total go to the operator in the dropdown menus... cells I3, I4 & I5

Of course, I can't thank you enough for helping me through this.

[ghostbroker2]

But using what you've shown me here, I applied a little brute force and copied this twice, once for I4 and once for I5 (and their corresponding totals). It is doing what I want, just a little clunky... takes a while, lots of screen flicker.

[xladept]

Hi ghostbroker,

You're welcome and thanks for the rep!

Maybe:

Please Login or Register  to view this content.

[ghostbroker2]

This is performing as advertised from my office.
I'm going to try it out on the floor.
I'll throw some more rep your way if it will let me.
Thanks again man

[xladept]

You're welcome - glad it's working - let me know - thanks for the vicarious rep!

[ghostbroker2]

Touchdown!

[xladept]

Let's go for two!