vba excel update outside files using Mumps1 code altered.

Hey Mumps1 shared this code which works perfect in its original form within the workbook,

My question for the code Mumps1 shared is, I was wondering if it would be possible to tweak it to work with updating an outside workbook?

I have tried to alter your code but keep getting errors, currently I getr an overflow error but if I declare v1 and v2 as Long then I get an Expected array message..... This is how I tweaked it for this purpose but not sure where my mistake is.

Basically I want to take the columns "B, C, T" when matched from "Ws" and paste to "Nws"

Please Login or Register  to view this content.

Here you go Mumps1,
The Public File is my source file like the one you helped me with already, the 2019 Qlty Data Public is the source file I want to update with column B, C, and T when they match the key in column A

I keep getting the overflow error

2019-04-30_09h08_49.png

Mybe this is a lost cause

So using your code it now runs without error but doesn't seem to update anything

Still no go, using these two records as a reference should easily see it update but everything seems to flow fine just doesn't actually update anything.


2019-04-30_09h49_01.png

and yes your correct, it opens the data sheet just doesn't overwrite B, C, or T with the new info from Today sheet

Well, preferably it would just update the last entry as it would be the latest occurence

OMGoodness, this seems to be it!!!!!!!

You are freaking amazing buddy!!!!!!

You are awesome, I truly appreciate the help I have been stumped on this one for a while now and no one could seem to give me a direction.

Thanks again truly