Insert row in numerical order

I'm up to more no good it would appear.

I need to be able to enter a number in a cell, A1 for example, activate a button, and have that value placed into a new row below in numerical order, then the entry in A1 deleted so more entries can be made

For example, if F1=6, G1=8 and H1=9, if I enter 7 in A1 and run the macro, a new row is created (G becomes H, H becomes I, etc) and 7 is placed in G1, A1 is cleared.

What I'm up to is inventory where the items are all numbered and more of the same number can show up with a larger number, like XXXX1 and XXXX2 that are the same item, or different item YYYY1 that may only show up once. Row gets deleted when inventory is removed from "back room" and goes to sales area so the list will only carry 40 or so items at any one time.

Creating the row isn't an issue - placing it between existing rows based on the existing cell values and on the new entered value I don't have any good ideas on.

My attached sheets show a before and after desired result

Hello itsunclebill,

I add this macro to button in the attached workbook. This will insert the new inventory data when clicked. The macro adds the new inventory items to the end of the list, provided there is room, and then sorts the inventory data. This places the new items in the correct place. Here is the button code.

Please Login or Register  to view this content.