Numbers, changing cell info on one sheet, changes cell on second sheet
I have moved a spread sheet across from excel, yes I am a happy convert, but I want o be able to replicate a simple invoicing system i set up on excel. There I was able to enter my invoice data on one sheet. From one line on the sheet, I was able to copy the data across to a second sheet that was set up as an invoice I could print fro my clients. The first sheet stayed as my accounts record, accumulating my records and eventually forming my records for tax purposes.
I can copy the information across on numbers manually, but I want to be able to enter the data onto one sheet, and it appear on the other automatically. I have tried copying the value, but it has not worked.
Thanks for any ideas
More about numbers, emailing one sheet only
Thanks for the advice. It works easily, but I do not understand why I could not find it the official help.
Next hurdle in this project is that I want to be able to email one sheet in the spreadsheet, not all sheets and tables. Any suggestions?