Updating worksheet and move data to another worksheet

Hi MrChiss,

Are you able to upload an example of the spreadsheet, as it makes it easier to understand what is required.

Thanks

Owen

Hi owenaldridge,

I have uploaded a file on how I want the outcome to be like. Hope it makes it more clear.

Chiss

Hi Chiss,

Just so I understand, can I ask why the "new data" cannot replace the "existing data"?

Will there sometimes be a date that is older on the "new data" that cannot replace the "existing data"?

Otherwise I think I know what you require:
1. Update existing table if "new data" has new record or a more recent date of an existing record
2. Place the updated existing records into "Traceability"
3. Place all updated records into "Updated data"

Is this correct?

Owen

Hi owenaldridge,

Yes of course. The reason for this comes in two parts. First and most important, the entire workbook needs to be validated by the FDA standards. Second there might be some cell colors in the "Existing data" that must not be overwritten since these marks the different rows and the information in the rows. The workbook is meant for medical purposes.

Yes you are correct. This is exactly what I am asking.

Chiss

Hi Chiss,

I think I have created what you need, the code is accessible by running the macro "Update_Data" or just click the command button on the "Existing Data" tab.

Note: The "Traceability" and "Updated Data" tabs are cleared every time the code is run.

I have created backup copies of the worksheets should you need them.

Let me know if this works for you!

Owen

Hi Owen,

It looks great and does the job quickly and almost as I would like it too - Thank you :-)

My only concern is that the "RecordID" will have to be in the same order (for the sheets "Existing data" and "New data") for it to work. But I guess this will be a good starting point for me to explore it further :-)

Unless you have an idea on how to overcome this obstacle?

/Christopher

Hi Chiss,

There is always a way...

Sorry, there was a simple fundamental flaw in the code.

Hopefully (fingers crossed) the attached should work for you this time.

Again let me know if it works (or doesn't work), I'm sure we can get to the bottom of this!

Owen