1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Auto sort column - within the same column in a spreadsheet?

Hello,

I don't know if it is possible but I want to make a list in column A but as I add new stuff to column A at the bottom I'd like Column A to auto sort - including the columns associated with it.

I don't want column D to be a sorting of what is in Column A - I want the column where you enter stuff to auto sort itself.

I have no idea if this is possible. It isn't critical - just curious.

For context we are making a spreadsheet

Column A is restaurant names

Column B it the type

Column C is the address

Column D is a rating from someone in my group

Column E is a rating from someone else in my group

Etc.

We are just making a list of places we've tried and giving them an average score.

As we try new restaurants we'd like to add them to the column A and then have it auto sort alphabetically.

Thanks.

submitted by /u/Deep-Egg-6167
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article