How do I copy over data to OneDrive but not copy specific data if not in OneDrive

I have a excel workbook that I have saved to one drive so numerous people can have open at same time.

I download data daily into a seperate workbook and then I want to merge it into the original workbook on one drive. This is where the problem is I don’t need it to copy over data that is NOT in the one drive file and is previous dates data.

Let’s say tomorrow I download data for all March and April and there is old and new data in the download. I need it to look in the one drive file and see if there any data not in there but in the download. This I don’t need copying and pasting over. There will be new data from the past 7 days in download and I do want this copying to the one drive

can that be done?

I had just literally posted and here is the link https://www.mrexcel.com/board/thread...-file.1201784/

Poated on here as looking for a quick answer

I just realised that the issue may not be as probermatic as I thought but dont know where to start.

In the file on the one drive the data that I have used will not be there in a particular row in columns A-D. Therefore when I download the new file in a seperate workbook I just need it to comapare data in columns A-D and if the row has no data in it then I need that row deleting from the new workbook.

All data is sorted into a particular order with same layout in both workbooks.

Also when ive done this and saved to one drive with other people logged into it it automatically updates?