Hi, struggling a bit here.
I have worksheet1 that has a dump for a system and then some extra colomns for comments etc. One week later I take the dump again, this time some of the records will have gone, there will be some new ones and various will be the same record but with some changes.
What I want to do is to update the old with the new but keeping my comments.
Colomn A is the record number so I guess it could perhap use that to paste in new data, add new record to the bottom and then delete any that are not on in the new dump on sheet2.
I hope this make sence, it would be a huge help to get this to work.
Regards,
Lee
I have worksheet1 that has a dump for a system and then some extra colomns for comments etc. One week later I take the dump again, this time some of the records will have gone, there will be some new ones and various will be the same record but with some changes.
What I want to do is to update the old with the new but keeping my comments.
Colomn A is the record number so I guess it could perhap use that to paste in new data, add new record to the bottom and then delete any that are not on in the new dump on sheet2.
I hope this make sence, it would be a huge help to get this to work.
Regards,
Lee