Macro for sorting multiple columns in a range

I have a spreadsheet that contains an inventory of data for negatives for a museum.

New inventory numbers may be added, and I would like a macro to insert the new data values in the proper column and rows in ascending order. The new numbers are not always in a sequential order, so they need to be "sorted" so they can be easily found when scanning the inventory sheet.

The range is important since the inventory sheet will be posted on the outside of the box that contains the negatives.

The range is columns A to N and from row 1 to 40.

For instanced
C1 C2
1451 2500
1500 2550



I want to enter numbers '0100 & 2501' on the last row (40) and have these values sorted (inserted) into the proper order.
I need a vba macro that can be ran to accomplish this where it considers all rows and columns.

How is the data sorted? By columns, ascending?

If so, all you have to do (I think) is record a basic sorting function and assign it to a button.

The data is sorted by column, ascending. Perhaps, I need to expand on the desired behavior I'm looking for.

I have 14 columns of data. All but the last column have data values in all cells to row 40. If I add new values, I would like the sort to put those values in their proper place. The new values may need to be in column 1 or column 12, etc in the range of displayed values. The standard sorts (or advance sorts) appear to be only doing a sort per column.

I will try to record the sort and assign it to a button.

Anything else am I missing?

To add to my above "desired behavior). What I want is to sort by Column A, then by Col A + Col B, then by Col A + Col B + Col C. etc until I've completed sorting all columns A to M. All in ascending order. If I highlight two columns and select sort, the data is only sorted by column, not by both columns. This is why I think I need vba to accomplish this sort task.

Does anyone know if this is even possible? Seems like it should be.

I don't quite understand the sorting conditions yet. Columns are filled with numerical values, right? You need each column sorted ascending. When new values are entered at the bottom, they get sorted too. What does it mean - sort by Column A, then by Column A+B?

For more complex sorting use the big SORT button and you can use ADD LEVELS afterwards, to set up Sort by Column A, then by Column B etc.

Hope this helps.