Here is what I am looking to do:
I have an master excel data sheet that contains information on properties going to auction which is pulled from a website. Every day I download new data from the site and I need to compare the new list to the old list. The master sheet is fed into a model so I want to preserve the location of the data in the master sheet and add new properties to the list at the bottom. I also want to know if 1 specific column has changed and then update the master sheet to reflect the changed data.
I have been able to compare the two files and see what is different but I have not found a good method to copy/export the changed/additional data back into my master excel sheet.
I feel like this should be easily doable with this program but I am under some time constraints and I would appreciate any help.
I have an master excel data sheet that contains information on properties going to auction which is pulled from a website. Every day I download new data from the site and I need to compare the new list to the old list. The master sheet is fed into a model so I want to preserve the location of the data in the master sheet and add new properties to the list at the bottom. I also want to know if 1 specific column has changed and then update the master sheet to reflect the changed data.
I have been able to compare the two files and see what is different but I have not found a good method to copy/export the changed/additional data back into my master excel sheet.
I feel like this should be easily doable with this program but I am under some time constraints and I would appreciate any help.
Comment