Mars reject
New Member
- Joined
- Feb 8, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I have been stuck for quite some time trying to figure this out. Essentially there is a pallet which needs to be loaded up with metal blanks to be machined by automation. The pallet has 4 rows and 24 spaces in each row. The first will start on row 1, group 1. If there are 4 types of this tool needed to be made then the next set will start at row 1, group 5 etc.
The part I'm struggling with is setting this up so that by only entering the quantity of the tools it adds the locations of them automatically. I'm particularly struggling with the last space so once it has been used the row is now 2 in the table and the rest carry over. So for example if there are 4 blanks which start at row 1, group 23 then it carries over the pair so rather than a new pair starting at row 2 group 1, it will instead start at row 2, group 3.
I hope I have explained this ok. I have attached a screenshot of the spreadsheet which I'd like to the locations update automatically rather than typing them in. In red are the rows and groups (locations and the part I'm trying to get to update automatically) and in blue are the quantities (which the user inputs, and the row/group columns update accordingly).
Thank you in advance for any help on this!
I have been stuck for quite some time trying to figure this out. Essentially there is a pallet which needs to be loaded up with metal blanks to be machined by automation. The pallet has 4 rows and 24 spaces in each row. The first will start on row 1, group 1. If there are 4 types of this tool needed to be made then the next set will start at row 1, group 5 etc.
The part I'm struggling with is setting this up so that by only entering the quantity of the tools it adds the locations of them automatically. I'm particularly struggling with the last space so once it has been used the row is now 2 in the table and the rest carry over. So for example if there are 4 blanks which start at row 1, group 23 then it carries over the pair so rather than a new pair starting at row 2 group 1, it will instead start at row 2, group 3.
I hope I have explained this ok. I have attached a screenshot of the spreadsheet which I'd like to the locations update automatically rather than typing them in. In red are the rows and groups (locations and the part I'm trying to get to update automatically) and in blue are the quantities (which the user inputs, and the row/group columns update accordingly).
Thank you in advance for any help on this!