Excel 2013 64 bit
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S |
---|
1 | AIRCRAFT REQUISITION FORM | | | | | | | | | | | | | | | | | | |
2 | | | | | | | | | | | | | | | | Last Saved: | | 05/05/2018 7:52:44 AM | |
3 | | | | | | | | | | | | | | | | Last Printed: | | 04/24/2018 8:15:10 AM | |
4 | Aircraft: | | | | | | | | | | | | | | | Trip Title: | | Test | |
5 | Requestor: | | | | | | | | | | | | | | | Lead Passenger: | | Test | |
6 | No. Legs | | 4 | | | | | | | | | | | | | Lead Pax Cell: | | | |
7 | | | | | | | | | | | | | | | | Rev. No. | | 2 | |
8 | | | | | | | | | | | | | | | | | | | |
9 | FLIGHT ITINERARY | | | | | | | | | | | | | | | | | | |
10 | Leg No. | Date | Charge TO: | Category | | | | | | | Origin | | | | | Destination | Depart | Arrive | Services |
11 | | | | | | | | | | | | | | | | | | | |
12 | 1 | | | | | | | | | | | | | | | | | | |
13 | 2 | | | | | | | | | | | | | | | | | | |
14 | 3 | | | | | | | | | | | | | | | | | | |
15 | 4 | | | | | | | | | | | | | | | | | | |
16 | | | | | | | | | | | | | | | | | | | |
17 | | | | | | | | | | | | | | | | | | | |
18 | | | | | | | | | | | | | | | | | | | |
19 | | | | | | | | | | | | | | | | | | | |
20 | | | | | | | | | | | | | | | | | | | |
21 | | | | | | | | | | | | | | | | | | | |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Hi Caleeco! Firstly, thank you VERY KINDLY for your willingness to help...unfortunately my example above lost the cleanliness of my hours of formatting!!
-User populates the leg numbers in C6
-Via in cell Formula, Cells A12:A21 will populate with that number, but of course, it currently leaves the remaining unused rows visible.
Cells D10 and S10 are subheadings for dropdown list columns, while all others are "free text" entry cells with autofit and wrapping (the users will type LOTS of notes)
-If the user, for example, were to begin the form with 4 legs requested, and then later changed to a number of legs that is greater than 4, I would like to retain any data entered for the first 4 legs, if at all possible. Ideally in that scenario, the additional leg rows would then appear for population. Using the same example, if the user needed to reduce the legs below 4, it might be best to have them start a new form using this "Master" and copy/paste any data that is still relevant.
Additional info that may be helpful:
VBA is used to generate a message box (Before Save) to the user if certain data is missing from a row that is eligible based on the cell C6 input (number of legs requested). eg, if 4 legs were requested, and only 3 legs worth of data was completed, there would be a message reminding the user to "Please Complete Leg 4 Info".
Thank you so much for your help!
B Squared