Forum Discussion
Sort and move data
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.
- Yea the auto type is tough when it comes to data. I appreciate all the help with everything.
- Here is a good one, is there a way to get this to work on a mac? Half our systems are mac and macros dont work, along with the Data valadation doesnt transfer over, which means I have to build the lists on every Mac for some reason.
I have no experience working with a Mac. I’m afraid I can’t help you with that.