I have a spreadsheet that I use to control & record all the sales & operations data in my work. It starts the year at zero rows & ends it on anywhere between 1000-2500 rows & has something like 20 columns as below:
What I'm trying & failing to do is create a macro, or more accurately modify someone else's vba code to make the rows on this sheet sort automatically, in ascending date order by columns H, then K, which are collection date & delivery date, each time a new job is added, so that the newest jobs are at the bottom of the worksheet.
Anyone handy with this kind of thing? I have looked on Mr. Excel & a few other places without success.