Please help!!!

Originally Posted by Baza171

Ive got a spreadsheet which im trying to enter information on sheet 1 but want it to record every entry on sheet 2 in a list type form. The trouble im having is that i have to delete sheet 1 with every new entry and it just deletes my info on sheet 2.

Please help any ideas!!!!!

Thanks for reading!!

how are you deleting sheet1 data, and what cells does the data occupy?
which column signifies that the dataline is finished (fully entered)

---

Originally Posted by Baza171

Ive got a spreadsheet which im trying to enter information on sheet 1 but want it to record every entry on sheet 2 in a list type form. The trouble im having is that i have to delete sheet 1 with every new entry and it just deletes my info on sheet 2.

Please help any ideas!!!!!

Thanks for reading!!

one possibility,

In sheet1, rightmouse the tab, and View Code

paste this code there.

Please Login or Register  to view this content.

when you delete a cell (or row) that row should appear on Sheet2

hth
---amended for multiple rows.