Worksheet Change Event log for multiple cells

P

Piotr (Peter)

Dear All,

I have a spreadsheet that is available here:
http://www.filefactory.com/file/b02e5h4/n/Worksheet_change_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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top