Nov 26 2021 02:56 PM
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
Nov 27 2021 11:22 AM
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.
Nov 27 2021 01:18 PM
Nov 28 2021 01:41 AM
See attached file. I hope this is what you want to do.
Nov 29 2021 07:43 AM
This is exactly what I am looking for, I added my data to it and it works great.
Is there a way to add a line of code to sort by start time after it sorts by date?
Thanks a ton and I attached our combined ones for reference, I basically have a lot of events on the same day and need them organized by start time.
Also, is there a way to have the data validation to auto populate when you start typing? Like if I start typing a date/lane option it will auto fill instead of scrolling through a year of dates?
Nov 29 2021 07:50 AM
Nov 30 2021 03:48 AM
I added a line of code in order to have the data sorted by start time after it is sorted by date.
I never did auto populate before but i am interested how this can be done and i found VBA code in the internet which i couldn't implement in the spreadsheet so far.
However i found a solution without VBA and implemented this in sheet "Tabelle2". It works for the lane options. I had to move the entry form down to row 72 in order to add the possible lane options in range E1:E67. For the date options the quickest solution is to manually type "13.03.2022" for example or to use the drop down list.
Nov 30 2021 12:46 PM
Dec 03 2021 01:32 PM
Dec 04 2021 02:15 PM
I have no experience working with a Mac. I’m afraid I can’t help you with that.