Excel Help/ Modelling

详细信息

I work in property in the UK and for an estate agency that sells properties. We have a subscription to a property website that gives us excel sheets each week which show us what properties are coming on sale. In each week the properties are listed by the number of days shown on the market. We can put a note in the sheet once this property has been visited.The following week, the property has been on for 1 more week, so that column number changes. This means that when you remove the duplicates, the notes get removed.Each week this site gives us new sheets to download. We need a way of mixing them all together or some kind of formula or method so we can update the excel sheet each week, so our staff know which the right ones are to visit. Is this a project you can help with please? Please advise. With thanks,Raphael