Help Needed Moving data and rows from different sheets while updating prior data.

Version: Office 365

What I'm trying to accomplish: I have uploaded a sample sheet to play with. None of this is the actual file just something to go off of and the types of columns I have.

I posted in general help and then realized that maybe this isn't so general of a request. So I am posting here as it seems a better fit.

I will attach a book and included is a copy of someone's crack at doing it with VBA. I am no expert in VBA and they are so close and I am unsure of how to modify this to make it work.

Here is what I am trying to do:

Everyday I paste raw data into my datasheet and there can be a lot of it. So I then have to manually go through and identify any cases that are currently being investigated on my master sheet.

What I'm hoping for is a VBA macro that I can have as a button to update the data from my data sheet. This will save me loads of time. I have tried to do this with Vlookup and Xlookup. I have made a macro to trim all the data I don't need in the other columns and what I'm left with is basically the ones that are seen in my book.

I am hoping to be able to click a button and run some VBA that will sift through the data for me and update my master sheet. If the service case is on the master sheet all I want it to do is look at the data sheet and replace the aging days number with the updated value. If the service case is not on the master sheet I would like for it to add the entire row to the bottom of the table as a new record. I can filter from there.


I'm really hoping someone with much more experience than I can recognize the issue and provide a fix.

Thanks for the help if anyone wants to attempt. I would be so grateful to have this off my plate. Also Would love to learn how it works so that I can add this to my toolbelt in other areas should they arise.

Thanks so much for anyone willing to take a crack at this.


** Bonus: if marked complete the row moves off the master sheet to the completed tab and counts what shift completed it. The columns are in the table but right now I am really hoping to get the data sifted through.