Forum Discussion
Solved
Help Needed: Nest XMATCH in h-linked drop-down to land on first blank record in the destination Tab
I'm sorry to post again. My last post was not clear enough. Lots of views, but no answers. I'm not very practiced at asking questions in the forum. Please bear with me and don't hesitate to offer pos...
Please stay on the cell with drop-down list, when on ribbon Data->Data validation. It looks like
In Source it could be text as here, or usually reference on the range within workbook. Expand reference with names of new tabs and correct the Source above. It will be like
- This is the BEST RESPONSE! Thanks again Sergei!!
Marcus_Booth , you are welcome, glad to help
- There is something additional that I would like to build into this project. Let me know if it's ok to post here, or if I should start a new discussion...
I have a table on which will be entered several hundred employees on a tab called 'Staff_List' which also has a column with the name of the office in which they work. When a user navigates to a given 'OfficeName Tab' from the directory that you have so graciously assisted with, and they go to pick a staff name from a drop down, I only want the names of the employees from that office to populate the drop-down under the 'Staff Name' column (based on the sheet name (specific office), instead of having them see the whole list. There are other columns of data that I want to bring in as well from that same 'Staff_List' table. Can this be done using a formula?
