michaeltsmith93
Board Regular
- Joined
- Sep 29, 2016
- Messages
- 83
Hi,
I wasn't exactly sure how to title this.
The idea is that I have a column of names on Sheets("DateAssigned") that are pulled from a list on Sheets("Tracker") using INDEX, and that list from Tracker is auto-filtered alphabetically. In the columns adjacent to the column of names on DateAssigned, I have dates that I enter manually. I'd like for these dates to be resilient to the alphabetization--that is, I'd like for the dates to move as the names move when they are re-alphabetized. Obviously, at the moment, alphabetization changes the order of the names on DateAssigned, but the adjacent dates don't move. Thoughts?
I wasn't exactly sure how to title this.
The idea is that I have a column of names on Sheets("DateAssigned") that are pulled from a list on Sheets("Tracker") using INDEX, and that list from Tracker is auto-filtered alphabetically. In the columns adjacent to the column of names on DateAssigned, I have dates that I enter manually. I'd like for these dates to be resilient to the alphabetization--that is, I'd like for the dates to move as the names move when they are re-alphabetized. Obviously, at the moment, alphabetization changes the order of the names on DateAssigned, but the adjacent dates don't move. Thoughts?
Last edited:
