Hi Everyone,
I have created a master list of employees. when a new person is added, there name is auto-populated to the data sheet. However I wanted a blank row inserted as well. In example A, Bob was added to the master list and his name was automatically linked to the list in the Data sheet. But the data between rows B-M are Employee B's.
In Example A there is the master list and the data that has been linked to Example B. The problem is highlighted in red. Thanks in advance for the help!
UPDATE: Something I forgot to mention but might help is that I created the list using this link: http://www.contextures.com/xlDataVal05.html
Bookmarks