I have numerous Invoices created in Numbers, same format, and saved in the same folder. I want to take information from each Invoice and collate on a single sheet.Can anyone help, or point me in the direction of where i should be asking this question.
iMac
Numbers can only refer to cells in the same file.
So the first step would be to move (copy and paste) each invoice into a sheet on a new document.
Once you have all the invoices in the same documents, then you can create a summary sheet
Numbers can only refer to cells in the same file.
So the first step would be to move (copy and paste) each invoice into a sheet on a new document.
Once you have all the invoices in the same documents, then you can create a summary sheet
ok thanks for your speedy reply. I understand this. Is it possible once Invoices are Moved in (Copied and Pasted) that the summary sheet automatically picks the info from each invoice? (Once Summary Sheet is created) Im looking at 100's of invoices and want to collate in one simple summary sheet to save myself time. I want to be able to paste in the invoice, and hey presto numbers updates all invoice data to the summary sheet. So each Invoice will get a specific row.
and further more to this, is it possible to have automator transfer the invoice once completed to the summary sheet file for this to work for me?
Probably best to post a sample of an invoice (screenshot) and what you imagine the summary would look like. When you post the screenshot of the invoice make up the data so it does not have any private information.
Transfer information from various Invoices to one summary spreadsheet
