WOudl someone be able to help me with some VBA, I have a sheet which has data in cells A1:D1000
I need the code to :
Sort the cells by column A then column B ( ascending ).
Look in cell E1 and the date that is in that cell.
Highlight all the data in cells A1:D1000 which in column A have a date which is inlcudin gthe date in cell E1 and for the next six days eg ( cell E1 = 15/6/08 so all data with dates in column A are fro 15/6/8 to 21/6/8 )
Then all that data copy this and paste this into a new sheet.
Any help appreciated.
I need the code to :
Sort the cells by column A then column B ( ascending ).
Look in cell E1 and the date that is in that cell.
Highlight all the data in cells A1:D1000 which in column A have a date which is inlcudin gthe date in cell E1 and for the next six days eg ( cell E1 = 15/6/08 so all data with dates in column A are fro 15/6/8 to 21/6/8 )
Then all that data copy this and paste this into a new sheet.
Any help appreciated.