niteNarmor
New Member
- Joined
- Dec 21, 2013
- Messages
- 4
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.
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.