Passing information between worksheets
 

Hi

I would like to know if you can help me with the following:

1) I am setting up an appointment booking system and when a visitor proposes
an appointment time and date, I would like this information to be kept within
this workbook, but also copied to a different workbook, which is managed by
an administrator. Then once it is held within the administrators workbook, I
would like there to be an option for the administrator to either the accept
or reject the appointment. If accepted, the visitors spreadsheet (who sent
the appointment proposal) should get updated. They should be able to see
whether it has either been accepted or rejected by colour reference i.e. the
appointment should change to green if it is accepted or go red if rejected.

Please let me know if this is possible? Thanking you in advance.

Passing information between worksheets
 

Hi

Are you talking about putting a spreadsheet on a network drive that can be
accessed by two different computers?

If so, only one user can have Write access to the file, so if you try to send
information to another book that is open on another computer you cannot save
the book and also, the other user wont know you have added / tried to add
more information.

If you really want excel to work this way, you would have put the information
in your book and SAVE it.
The other book would then have to have a update button that can be pressed to
check your book for new entries, and then write them to there book.

Your book would then also need an update button to see if they accepted it

Thats one the simplest way of doing something like that i suppose

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200812/1