I'm setting up a table that has a lot of droplists and formulas. Column A is a droplist with names. The way tables work, they won't absorb new data until at least 1 cell in the new row has been filled. That doesn't work if it's important for the user to select from a droplist.
So, the goal is to always have a new row available for the user to enter data into.
Do you have a question? Or are just offering a tip?
BTW to solve this I would set up column A with data validation for the entire column, then you don't need to mess with a blank row. See attached example.
Ah! I see how this seemed like I was offering a tip. No. I was asking a question and you offered a simple solution. It works.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks