Good day to all,
I'm running into a problem with attached file.
First sheet is a daily entry form, 2nd, 3rd, 4th and 5th sheets are rolling documents, pulling the data from the first sheet.
In the first sheet, only the blue fields are filled with data.
E1 is invoice number, E2 is invoice date. Other fields are data from that specific invoice.
Table shown in B4:F11 is pulling the overall data from that first sheet.
The other sheets in the file are then pulling their respective data from that table (sounds difficult, but is pretty straight forward).
Now comes the challenge ;-)
As soon as I enter a new invoice with its specific data, the data in the other sheets is changing as well (as it's linked to the overall table on the first sheet).
Is there a way that when I enter an invoice with its data, the table on the first sheet is filled, the other sheets are filled as well, but then the data on these 2nd, 3rd, 4th and 5th sheet are e.g. paste as value, so that when I enter another invoice, that specific data is then copied on the next empty line in these sheets?
I hope I've made myself a bit clear, if not, please feel free to ask!!!
Thanks all for your help in this, really appreciate it!!
Kind regards,
Peter
veiling.xlsx
Bookmarks