Hello All, thank you first of all for all the help! Love this forum, people are so responsive and helpful. I'm learning from everyone. New question - The Customer column populates from a pull down list and can be updated on the fly using a nice macro you all provided. But now I have to give the Customer a ranking letter A, B, C etc and have that populate in the Ranking column when Customer is selected. However, I still want to be able to populate on the fly for both Customer and Ranking but link them so if Customer Mohawk is selected it would display the ranking B.
To further complicate this, the Customers automatically sort Alphabetically so the Ranking letter would have to stay associated. Does that make sense?
I've attached the file. Thank you again in advance for the help!![]()
Bookmarks