Copy date between Worksheets depending on Date in row

10degrees

New Member
Joined
Jul 16, 2013
Messages
1
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... :nya:

Thanks... J
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top