View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
terilad terilad is offline
external usenet poster
 
Posts: 141
Default Create a log sheet

Thanks Gord, will email a workbook to you.

Regards


Mark

"Gord Dibben" wrote:

It can be done using Workbook_SheetChange code but much more detail is
required.

How do these cells on your 100 sheets become populated/changed?

Manual entries one cell/sheet at a time?

You have 4 columns of data...............how many cells in each column?

Which column(s) or cell(s) change would you want to trigger the code?

Would you want the triggering cell's address also logged to logsheet?

If you want you can send me a workbook with a clearer explanation of your
wishes.

email to gorddibbATshawDOTca change the obvious.


Gord

On Thu, 15 Apr 2010 12:47:02 -0700, terilad
wrote:

Hi Gord,

I have 100 sheets all with names of stock items, syringes, needles etc, in
these sheets I have 4 columns Date, Amount of stock in or out, Balance of
stock and persons initials, what I am looking to is log the entries that
appear in these sheets on one log sheet with date and time, pc name and user
name.

The colums in the stock sheets are A, B, C, D

Regards


Mark

"Gord Dibben" wrote:

I don't understand the part about sampling of data per sheet name with the
number added or taken off.

Please provide more details on what you visualize.


Gord

On Tue, 13 Apr 2010 12:50:12 -0700, terilad
wrote:

would be good to have a running accumulation on sheet named log, with
sampling of data per sheet name with the number added or taken off and the
initials entered. These are all data that is entered onto these stock
sheets, also would be be good to record events such as macros that are run on
the workbook.

Many thanks

Mark

.


.