Duncan,
Is it possible to date/time stamp entries in a "spare"
column and are all entries new or can there be updates to existing entries?

You could use the "Worksheet_Change" event to monitor changes and record
new additions by matching the unique ID against existing ones; if not matched
then it must be new.



"Duncan" wrote:

Hi all,

I am stumped as to how you would get some form of notification when
something is added to a 'master' spreadsheet.

If many people were using this spreadsheet and adding a row of
information (an entry), each entry having a unique identifiable number
in column A, how would you get something out once a day which said
"number, number, and number have been added" taking the numbers from
column A for each new entry?

Is this possible? i am thinking perhaps an email, or populating a
report, or any form really perhaps even printed but reliable so ones
that were added were not missed.

So for instance,
Darren would use the sheet from 9 til 12 adding entries,
Duncan would use the sheet from 12 til 3 adding entries.
at 4 o clock an email/printout/report would come from somewhere and get

given to Jon who would then know what new entries had been added.

Any ideas?