I attach an example spreadsheet where I am trying to automate a process.
It shows a table whereby changing the number of Units required in cell B2 to a validated number, the number of Items A, B & C required are shown in Row 2. These required Items are calculated in the table from 6 Sources for each Item. The number of Items from each Source can only be whole numbers.
Any ideas anyone?
Attachment 29013
Bookmarks