Copy master wb/ws to new wb/ws to overwrite data only if column a info matches both

Hello,

I have a workbook - "DB Master," with several worksheets, and another workbook - "Dashboard_A", which also has several worksheets.
I am trying to copy data from specified columns of the "Master" worksheet, from the "DB Master" workbook, to the "DB Billing" worksheet of the "Dashboard_A" workbook.

Workbooks are not in the same folders, but they are on the same drive. I would like to be able to keep the "Dashboard_A" closed when running the macro.

I was able to get the copy/paste function to work with the macro below, and also in the attached workbooks, but when I run the macro, it removes all previous data and replaces with the new.

What I need is for it to look at column A of both worksheets, and if the names from column A matches, it will update the values only from the specified columns,
but, if a new name is added to the Master ws, it will create that new name into the DB Billing ws - as a new entry.

I may be running the wrong macro all together, so any help or advice would be greatly appreciated!

Current Code:

Please Login or Register  to view this content.

Sorry - forgot it was protected. Password is Jason.

I want to check if the name in column A of the DB Billing Sheet already exists and has a match to the Master sheet, then update the numbers from the master to the db billing.
if the name does not already exist in the db billing, but does exist in the master, i need the name and data to be added to the db billing.
if there is a name/data in the db billing ws (that is not in the master), I need it to be "left alone" - as is.


From the Master ws, I need column A to column A of the DB Billing ws
From the Master ws, I need column D to column B of the DB Billing ws (1 = 3)
From the Master ws, I need column F to column C of the DB Billing ws (2 = 5)
From the Master ws, I need column H to column D of the DB Billing ws (3 = 7)
From the Master ws, I need column R to column E of the DB Billing ws (4 = 17)



Hope that all made sense .

Hello Mumps1,

The macro you provided Works Perfect (I have so much to learn)!

thank you so much for your help and time!!!

Kindest Regards,
Paula