the short answer is yes but requires some work

Rons site gives good guidance how to do this.

http://www.rondebruin.nl/copy1.htm
--
jb


"sparkes84" wrote:

Hi, is there a way in which data that is entered on one screen is copied to
a different sheet and placed on a new row so that previous entries are not
over written? Also, to then delete the data entry on the first sheet for
the next data entry? In a way, I'm asking for similar functions to those in
Access, but I have to use Excel for this.
ALL help gratefully received! Many thanks