We have a workbook with column A1:A100 containing different company names. B1:AA1 contains multiple products and services.
Each company has the relevant data (versions, dates) filled in about each product or service. This could be in the form of a a number, text or date formatted cell dependant on the product of service. The workbook is completed by multiple people.
It is a 365 document and I can see multiple versions of the sheet going back 18 months
Goal: to show, in the least manual way possible, the progress of versions and/or services over the time period we have been tracking them.
At the most basic a compare of the very first and very last iteration of the sheet just about will suffice but I was wondering if there was a more automated way of show the changes over time, rather than just use the compare function as above.
Any suggestions gratefully received!
Each company has the relevant data (versions, dates) filled in about each product or service. This could be in the form of a a number, text or date formatted cell dependant on the product of service. The workbook is completed by multiple people.
It is a 365 document and I can see multiple versions of the sheet going back 18 months
Goal: to show, in the least manual way possible, the progress of versions and/or services over the time period we have been tracking them.
At the most basic a compare of the very first and very last iteration of the sheet just about will suffice but I was wondering if there was a more automated way of show the changes over time, rather than just use the compare function as above.
Any suggestions gratefully received!
