ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing changes in worksheets and reporting them (https://www.excelbanter.com/excel-discussion-misc-queries/94986-comparing-changes-worksheets-reporting-them.html)

Kostak18

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!

CLR

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!


Kostak18

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