hi
i have used text to columns to split up a date ,j column i moved to z column and used text to columns to split into 3 ie wed /thursday/0800hrs ,my problem is i want to auto arrange column j in day and date not bothered about the time ,when i expand selection to cover full sheet it moves up one row and puts everything out,my intension was to put the sheet in order and then copy mon to mondays sheet ,tues to tuesdays sheet ect but are having problems knowing the best way
each week i have a down load that i enter in load data and send to sheet 2 after applying filter in macro2 which works well
its only the last bit of sorting day and date in order and sending to appropiate sheets ,has any one got any ideas as best way to do
cheers colin
Bookmarks