Hi. I am using Excel 2010. I am making a list of vinyl records and their value. I have my columns set by the artist, ebay price, popsike.com price, and my listing price. I have summed my listing prices together so that I know my total estimated value of all the albums.
My question is that I would like to alphabetize this list by artist. This will make it easier for me to locate the albums in my list. However, I want to keep the entire row linked together when it moves, and not lose my sum formula for my listing prices. How would I accomplish this?
Bookmarks