Forum Discussion
Sort and move data
I am looking to create a macro that sorts data and moves it. I have a list of dates/times and I want the top row to be where the data is added, but not the top row of the data after it gets sorted.
I attached a screenshot for reference. Basically the employee types the info in the boxes with the border, clicks the button (that has a recorded macro/or whatever is needed) and that data gets added into the bottom portion and sorted by oldest to newest date. After you click the button the boxes with the border go back to blank and they can type in the new information again and sort it.
The only thing I can do is sort it but it always adds the data back into the input boxes, which I want blank after the sort
9 Replies
In the attached file you can enter data in range A2:F2 and then click the button in cell H2. Maybe this is what you want to do. Currently the macro sorts data that is within range A6:F10000.
- Yea, I used what you sent and modified.
Now if I could keep the format (ex keep the main boxes where they are adding data) to a different color or a border and it wouldnt sort it when you click the button it would be great.See attached file. I hope this is what you want to do.
