Dear All,

I have a spreadsheet that is available he
http://www.filefactory.com/file/b02e...ange_event.zip
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).

I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.

For example: Column A from a worksheet €žTotals€� corresponds with column A in
a worksheet €žCases€� so logging should be added for any change one by one in
the worksheet €žTotals€� starting from column B1 for text1, C1 for text 1 and
so on. Similarly, for €œtext 2€�but starting from B2 then C2 and so on.

I am new to VBA and have no idea how to do this and such details are
required for management information. Any help would be greatly appreciated.
In a zip file there is also password for to protect a worksheet in case you
need it.

Kind regards,

Peter

Can anybody help me please?

Thanks,

Peter

"Piotr (Peter)" wrote:

Dear All,

I have a spreadsheet that is available he
http://www.filefactory.com/file/b02e...ange_event.zip
(although I scanned it for viruses please make sure you do it again prior to
opening it as I cannot guarantee it's worm free).

I would like to create a log file in an additional sheet (hidden probably)
that would record every activity from column E after clicking a button
assigned to a cell in that column and show these records in a worksheet
Totals in a specific row.

For example: Column A from a worksheet €žTotals€� corresponds with column A in
a worksheet €žCases€� so logging should be added for any change one by one in
the worksheet €žTotals€� starting from column B1 for text1, C1 for text 1 and
so on. Similarly, for €œtext 2€�but starting from B2 then C2 and so on.

I am new to VBA and have no idea how to do this and such details are
required for management information. Any help would be greatly appreciated.
In a zip file there is also password for to protect a worksheet in case you
need it.

Kind regards,

Peter