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 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.