2) BACKGROUND: I am having my technicians fill out this form for every car that comes in. This form includes what mechanic shop they are at, date of issue, and then the removal reason (why the car is at the shop). There is a section that is the same and filled out for every car that comes in (i.e fluids check, oil level check, Computer analysis etc). HOWEVER, there is a another section where additional data/checks is requested based on the removal reason/car trouble. The removal reason is a drop down box selection, and using the Vlookup function, I have a smaller table set so that when a removal reason is selected, the additional requested checks appear for them to fill out.
3) ISSUE: Some removal reasons currently do not have any additional requested data, and the blocks there are just empty and the form looks incomplete and unprofessional. Another issue is that there are varying amounts of additional data requested.
4) QUESTION: Is there a code that I can implement to make cells appear (and shift the subsequent surrounding cells down) if the removal reason selected has additional data requested?
5) SCREENSHOT: I did not see a place to insert a sample of the file so I just took some screenshots.
5.1) Shows the tables, the form. The Additional Data section is the table with the Vlookup table with no values in the table.
5.2) Screenshot with Removal reason selected and subsequent additional data populated.