Customer details

Originally Posted by Baza171

Hi ive enclosed a speadsheet which im trying to enter customers details on sheet 1 and make it copy the details ive inputted on a seperate sheet. I need it to save all entries i input but every time i delete details on sheet 1 it deletes the details off sheet 2.

im just trying to stop this from happening and to save all entries.

Any ideas guys???

Thanks

your data entry sheet was able to take the values, and your formulas on your work done sheet were able to take the active values, but you need a process to write the values to Work Done.
I just added a simple array that takes the values you've inputted into your entry sheet and writes them to the second page.
I have very little context as to what you're trying to do and just tried to replicate the formulas you had.
Hope it helps

hope this helps