Hello all,
I am working on a new project for my company and it involves creating a pdf form with multiple drop down boxes. I am currently building the form in excel and have the basic form layout all set up in a sheet. I am now working on a separate sheet within the same workbook that will contain all of the data required for the drop down list options that users can select from. I started to build my tables so that I can use Data Validation and create a list in my pdf that can be clicked on and provide easy drop down options for the user to select from instead of them having to enter it in manually. I have created multiple lists in several columns with ten or so rows below them. The problem is that if I forgot to add something to one of the lists at the top and need to add a row, it then adds a row to all of the lists within the sheet and creates blank cells within my data. Is there a way to make it so that if one list requires additional cells to be added that it wont affect others lists. I have tried to google this but only can find things about locking, freezing, and grouping cells. I don't want to lock the cells and prevent future users from being able to edit the lists, but want the data within the list to not move. In addition, if future users need to add cells (for example 20 new states that we operate in) to a current drop down list, will the range of data be updated automatically without affecting other lists around or below it?
Bookmarks