Moving rows to middle of sheet under a title

[niteNarmor]

New to VBA.

I am trying to learn how to move rows in a sheet under a line of text. This is not a predefined row the text sits in. The row number the text sits in will change depending of the information above.

For example, there is an order which was placed and sits somewhere in top portion of the worksheet which changes hourly based on orders taken and orders shipped. Once the order is printed, then it needs to move below a line a text "Ready to Ship". Because all this information is in one sheet, that line of test moves with the number of orders taken. Line of text could be line 100 but next hour could be 85 or 135.

Is the above even possible? I have seen the rows being able to move to different sheets or bottom of existing data but not in the middle of sheet.

 

[My Aswer Is This]

You said: Quote
Once the order is printed, then it needs to move below a line a text "Ready to Ship"
Unquote

Where on the row will we find "Ready to Ship"
Will it be column J or column B or ??

And I do not know how to have a script run when you decide to do a printing of the order.

So lets just say when you double click on column A of the row you want moved the script will run.

And so if you have 20 such rows with Ready to Ship in column J where will this row be moved to?
After the last row with Ready to ship in column J ?

To help I need more specific details like this.