I have to make a daily production sheet. I can do this simply with 2 fields: ‘Machine Number’ and ‘Amount’. The ‘Machine Number’ is a linked field from another sheet named ‘Machines’. It works. But I have to pick the machine number everytime and there are 20+ machines.
I have tried making a sheet with 20 fields each named with the specific machine number, but then they cant link back to the ‘machines’ sheet. So some reports like pivot table wont work.
Is there a way to populate all the 20+ machines automatically?