Prev: SQL General Help
Next: If And formular Or somthing else
From: Piotr (Peter) on 19 Feb 2010 09:18
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

From: Piotr (Peter) on 25 Feb 2010 09:39
Can anybody help me please?

Thanks,

Peter

"Piotr (Peter)" wrote:

> 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
>
 | 
Pages: 1
Prev: SQL General Help
Next: If And formular Or somthing else