Notification upon submission of data?
 

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.

Any ideas?

Duncan

Notification upon submission of data?
 

perhaps i should explain a bit better after re-reading that, they would
not be adding at the same time, and possibly having a set time to use
it.

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.

Does that read a bit better? I have a tendancy to rant when i get
typing, apologies!