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