Hello Everyone,
I believe this may be the first time I have ever signed up and posted on a public forum like this; exciting! My first excel sheet is simply titled "name sheet." This is where client names are entered. I have two other sheets, with a couple more to come, that I also need to have the same client name entered into. On the other sheets I entered "='Name Sheet'!A2" This will autopopulate names as they are entered on the name sheet. I dragged this equation down about 1k cells; however I only have 80 names entered right now. The blank cells have generated a zero "0". When I go to sort the names alphabetically after entering new names, all the cells with zero in them move to the top and my names are sent to the bottom.
Did I formulate the equation wrong to auto populate the names, or is their a way to automatically sort the names while excluding the 0's. I do know when filtering I can uncheck the "0" to exclude it from being sorted, however I have to make this program as simple and user friendly as possible. Thank you all for your time.
Attached is a example of what I am dealing with.
Bookmarks