Suggest you send this to the programming newsgroup if you get no answer
here.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Lucy" wrote in message
...
"I have an excel spreadsheet that has 2 sheets, one has a list of open
issues" and one a list of "closed issues". One of the fields on the "open
issues" sheet has a "closed date" field. Whenever a date is typed into
this
field, I would like for it to be moved to the "closed issues" sheet, to
avoid
duplicate, manual entries being done. Can anyone help me with the best way
to
achieve this? Can this be achieved by using Macro's.

Any help with this, would be greatly appreciated.

Thanks!