Hi,
I'm after some help to try and speed up my job of comparing two months worth of data. Each month I get a download from the system which details all the deliverables that are due to be delivered to the customer. The spread sheet looks like the one below.
The document that I recieve has around 900 lines of deliverables listed with new and old being added and deleted each month and part of what i have to do is to compare the current months data with the previous months data and highlight any discrepancies within (excluding the comments column as this is updated monthly)
At present I copy and paste the information side by side and then go right through the two lists aligning the deliverables by ID number as the data is not always in the same rows. As you can imagine this takes hours to complete. I then use If statements that compares last months required date with this months required date, forecast dates, actual dates, deliverable type, etc. to give me a simple 'Yes' or 'No' result on whether the data is the same. If its not then I can see what has changed. Doing it this way is really long winded and takes best part of a day when i'm sure there is an easier way to do it.
Can anyone help with some VBA that will compare two worksheets and automatically highlight to me the differences between last months and this months data, any new deliverables that have been added in month and any deliverables that have disappeared between months.
I hope the above makes some sense and any help is greatly appreciated.
I'm after some help to try and speed up my job of comparing two months worth of data. Each month I get a download from the system which details all the deliverables that are due to be delivered to the customer. The spread sheet looks like the one below.
The document that I recieve has around 900 lines of deliverables listed with new and old being added and deleted each month and part of what i have to do is to compare the current months data with the previous months data and highlight any discrepancies within (excluding the comments column as this is updated monthly)
At present I copy and paste the information side by side and then go right through the two lists aligning the deliverables by ID number as the data is not always in the same rows. As you can imagine this takes hours to complete. I then use If statements that compares last months required date with this months required date, forecast dates, actual dates, deliverable type, etc. to give me a simple 'Yes' or 'No' result on whether the data is the same. If its not then I can see what has changed. Doing it this way is really long winded and takes best part of a day when i'm sure there is an easier way to do it.
Can anyone help with some VBA that will compare two worksheets and automatically highlight to me the differences between last months and this months data, any new deliverables that have been added in month and any deliverables that have disappeared between months.
I hope the above makes some sense and any help is greatly appreciated.
