Expanding list

Hey guys, doing an excel sheet for work and normally I do pretty well with programming but got stumped on a feature some coworkers want on their Excel sheets.

Basically heres what we do:

We manage vessels entering the port, and use a single excel file to build and compile all of our necessary documents for customs and documents/stowage plans for the ship owners.

How It is set up, we have a data sheet where the Agents here can enter the name of the ship, date of arrival/departure, and other information that other excel sheets link to to automatically fill out the data required. Basically they only have to enter the information once and all of the forms get filled out.

Heres my question. On one of the particular forms we have to show the amount of cargo that is in each of the holds of the vessel. The vessels have anywhere from 5 holds to 10. How can I create it so that on the data page, if information is only input for holds 1-5, that on the other form, it only shows 5 holds but then expands to show 10 holds for the times the ship has 10.

Ill show you what I mean:

Data Page: | Cargo Page:
Hold 1: 25 | Hold 1: 25
Hold 2: 22 | Hold 2: 22
Hold 3: 24 | Hold 3: 24
Hold 4: 11 | Hold 4: 11
Hold 5: 32 | Hold 5: 32
Hold 6:
Hold 7:
Hold 8:
Hold 9:
Hold 10:

So with that rough drawing you can hopefully get what im talking about.
Holds 6-10 are left blank on the data page. But if I were to input numbers in the fields for those blank holds, I want it so that it would continue the list on the Cargo Page by inputting: "Hold #:" (where "#" = respective hold)

Basically a binary toggle so that if a number shows up next to the hold, it toggles on the Hold# on the Cargo page.

Hope that makes sense. Thanks for any help. If you need clarification, please let me know...I know it is kind of confusing.

~Rob

Hi Rob,

See attached example ...

HTH

Exactly what I needed! Thank you much!