New Entries Added to List Don't Sort Using Macro

[bvpenny1]

I have a massive spreadsheet I use to catalog my books--I've attached one sheet from the workbook here. Within the workbook, I've created a handful of macros to sort the books in different ways. When I created the macros, I included a couple thousand rows in the 'sort', even though I currently have less than a thousand entries (that way, when I add more entries into the sheet, they will be included in the 'sort'). Each macro has then been assigned to a button.

However, whenever I add a new entry into my spreadsheet, the macro's don't include the new entry in their sorting (i.e. it will sort all entries above the new entry, but will leave that entry untouched in the row it was entered).

What is going on? Are my macros screwed up? Thanks for your help!

Yours,
Brandon Vogt

[jeffreybrown]

Cross Post

http://www.mrexcel.com/forum/showthread.php?t=501490

[stanleydgromjr]

bvpenny1,

Detach/open workbook bvpenny1 - EF749191 - SDG10.xlsm and add some new entries.

Then click on your buttons to sort the data.