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.
- bradford252Nov 27, 2021Copper ContributorYea, 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.- OliverScheurichNov 28, 2021Gold Contributor
See attached file. I hope this is what you want to do.
- bradford252Nov 29, 2021Copper Contributor
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?