Hello,
I have a large list of orders and would like to condense it down to only the orders I am sending. This needs to be down on a weekly basis, so the rows will not always be the same number. I thought using a user form to select and delete the rows specified would be the easiest way, but I am not sure how to do that.
For example, the user would type in the user form : 5,16,29,34,45 and every row that includes data besides those rows would be delete. Rows 5,16,29,34,45 would now be 1,2,3,4,5,6
Anything will help!
thank you
I have a large list of orders and would like to condense it down to only the orders I am sending. This needs to be down on a weekly basis, so the rows will not always be the same number. I thought using a user form to select and delete the rows specified would be the easiest way, but I am not sure how to do that.
For example, the user would type in the user form : 5,16,29,34,45 and every row that includes data besides those rows would be delete. Rows 5,16,29,34,45 would now be 1,2,3,4,5,6
Anything will help!
thank you
