Trying to copy data to a new sheet and row
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
|