Hi
I am starting to realise I know very little about excel.
I regularly recieve workbooks that contains 10yrs of data. A workbook will have approx 2400 rows of data and has columns up to AX.
What I would like to do to make it easier to play with the data is to split it up based on finanical years (eg 1/07/2000 to 30/06/2001) and have it COPIED on to a new worksheet for each fin year. I have been filtering and copying it manually but this is getting to be a headache as I am getting plenty of these things on a reg basis.
I have played with macros to automate the process but I have no idea what I am doing. Can anyone help a noob out?
BTW The column containing the date is column J
I am starting to realise I know very little about excel.
I regularly recieve workbooks that contains 10yrs of data. A workbook will have approx 2400 rows of data and has columns up to AX.
What I would like to do to make it easier to play with the data is to split it up based on finanical years (eg 1/07/2000 to 30/06/2001) and have it COPIED on to a new worksheet for each fin year. I have been filtering and copying it manually but this is getting to be a headache as I am getting plenty of these things on a reg basis.
I have played with macros to automate the process but I have no idea what I am doing. Can anyone help a noob out?
BTW The column containing the date is column J