Forum Discussion
Sort and move data
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.
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.
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?
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.