Vba to sort multiple columns as one list

Hello, I have searched everywhere, so it seems, and can't find the solution anywhere. I have created a list of movies that I own in an excel sheet (2007) and have it go down 50 rows in Column A before I continued the list in Columns B, C and D for now. I am trying to find a way to make the entire list sort instead of just the columns. I like to be able to see all of the titles on the page without scrolling down. When I add a new movie I would like to be able to add it to the end of the list and then sort it and have it go where it belongs no matter which column that may be. I am hoping this is possible. To make it even better, it would be ideal to have it automatically sort when I add a new title.

I propose NickyC's code with some changes, working on cells instead of arrays, I assumed the films list is not too long.

Please Login or Register  to view this content.

Hi
I have tested both macros and they seem to work.
do you know how to copy and run a macro? here's how:

• press alt+F11 to open the VBA area
• select insert > module
• copy the code from this website and paste it into the VBA module you just inserted
• Return to the spreadheet. On the developer tab, select macros and click the name of the macro you want to run

if you cannot see the developer tab:

• Click the File tab
  Click Options
  Click Customize Ribbon
  Under Customize the Ribbon and under Main Tabs, select the Developer check box