Hullo:
Whilst I am a new registrant here, i have frequently spotted Mr Excel queries and responses in my many Google searches. I wonder if anyone can help me out with this one.
I am running Excel 2010 (and 2013 but 2010 is fine);
I have a "Data" worksheet which is essentially a raw import of data from a .csv file; this is achieved through use of some VBA code...
This Data worksheet contains financial transactions; the first row being the transaction date; the .csv is exported from my bank so contains the last 12 months' or so transactions.
I also have other worksheets for each month of the year into which I want to populate the relevant date from the Data worksheet.
So, on each worksheet I have a "Start" and "End" date; I want to copy any rows of data from my Data worksheet into the "Month" worksheet using VBA that fall between (and including) these dates.
I'm thinking this probably needs a "Match" function but I'm really not sure where to go with this...
Can anyone help? Coffee's on me for the accepted solution...
Thanks... J
Whilst I am a new registrant here, i have frequently spotted Mr Excel queries and responses in my many Google searches. I wonder if anyone can help me out with this one.
I am running Excel 2010 (and 2013 but 2010 is fine);
I have a "Data" worksheet which is essentially a raw import of data from a .csv file; this is achieved through use of some VBA code...
This Data worksheet contains financial transactions; the first row being the transaction date; the .csv is exported from my bank so contains the last 12 months' or so transactions.
I also have other worksheets for each month of the year into which I want to populate the relevant date from the Data worksheet.
So, on each worksheet I have a "Start" and "End" date; I want to copy any rows of data from my Data worksheet into the "Month" worksheet using VBA that fall between (and including) these dates.
I'm thinking this probably needs a "Match" function but I'm really not sure where to go with this...
Can anyone help? Coffee's on me for the accepted solution...
Thanks... J