Hi Paul,
Hope you are doing great. The task you have requested can be achieved by coding a macro, which sorts the data by GUID, and a secondary sort by date. The objective of getting individual GUID's with total number of changes and last change value can be achieved by combing through each GUID, and tracking those changes. It will not matter if the user enters enters data in a sequential manner, as the macro would sort it anyways. What is more important, is that there has to be a user form (its a small excel based pop-up box) which will enable the users to put in the data in the right column i.e, users don't see the database. They just enter the data on the front end, and excel ensures all data is put in the right column, to avoid any mismatch (e.g price change put in column for miles etc)
I can create this tool for you within a days time, and I am sure you will be very pleased with the results. If you can chat me with, I can create a demo for you within a couple of hours, and only if you like what you see, you can award the bid to me, no commitments!!
I have over 10 years of experience in excel working for corporate companies like Dupont, Accenture, Volvo and TCS. I am new to Freelancer, and proposing a minimum bid just to get some work on my profile and ratings. I assure you that your work will be completed to your satisfaction and on time. I hope you will give me this opportunity. Have a nice day!!
Regards
Amin