![]() |
Comparing changes in worksheets and reporting them
Can anyone help me with this problem? I have a spreadsheet full of prices,
names of materials, dates, etc. that are all subject to change. When these cells are changed I would like to be able to compare them to the earlier version and then report on all the changes in a neat manner on a third worksheet. Formulae and/or VB is great, but I am very weak with code. If you can help please also explain as thoroughly as possible. Thank You! |
Comparing changes in worksheets and reporting them
If this is something you have to do regularly, I would recommend Jim Cone's
fine commercial Add-in called XL Companion. It does this, and many other helpful things. It's available at http://www.realezsites.com/bus/primitivesoftware Vaya con Dios, Chuck, CABGx3 "Kostak18" wrote: Can anyone help me with this problem? I have a spreadsheet full of prices, names of materials, dates, etc. that are all subject to change. When these cells are changed I would like to be able to compare them to the earlier version and then report on all the changes in a neat manner on a third worksheet. Formulae and/or VB is great, but I am very weak with code. If you can help please also explain as thoroughly as possible. Thank You! |
Comparing changes in worksheets and reporting them
Not looking to buy anything I 'm just looking for something simple.
Thanks. "CLR" wrote: If this is something you have to do regularly, I would recommend Jim Cone's fine commercial Add-in called XL Companion. It does this, and many other helpful things. It's available at http://www.realezsites.com/bus/primitivesoftware Vaya con Dios, Chuck, CABGx3 "Kostak18" wrote: Can anyone help me with this problem? I have a spreadsheet full of prices, names of materials, dates, etc. that are all subject to change. When these cells are changed I would like to be able to compare them to the earlier version and then report on all the changes in a neat manner on a third worksheet. Formulae and/or VB is great, but I am very weak with code. If you can help please also explain as thoroughly as possible. Thank You! |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com