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
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