Copy Rows To Predefined Sheet Based on Date Range Using Form or Message Box

Hello,
Need to copy rows of data based on a range of dates from multiple work sheets (Name1,Name2,Name3) and looking at dates on each row in column “M” to a predefined work sheet (Budget). Using either a calendar form or message box initiated from a button on the predefined work sheet “Budget”. The data on work sheet “budget” will be overwritten each time excluding the top row, as this will be a header. Normally I can cannibalize found code enough to make it work, but have no idea on this one.

To further complicate things the first two sheets (Dropdown,Insert) are normally hidden, work sheet (Name1,Name2,Name3) and the work book itself is protected and shared.

Hope someone can help, Thanks

So what should be the condition for the data to be transferred?

Isaac, i will look into this first thing tomorrow.

Quick question - how do you trigger the form to open? Are you using any shortcut key combination?

One important question - If there is data already in the budget sheet, do you want it to be cleared before running the macro?

Double-click on the first button on your form and put this code in the code block that appears -

Please Login or Register  to view this content.

As long as your format is the same as your test file, it should work. Are you getting any error.

It partially works and i know the issue lies with the date formats. Will try and work something out to get this sorted.

Does this help:

Please Login or Register  to view this content.

I'm entering days as d/m/yy and it works. Try other formats.

Thank you Zbor.

I put in data in the dd/mm/yyyy format into the form and it works correctly. If i put mm/dd/yyyy, it doesnt.

Also Isaac,

You should ensure that both the text boxes have dates in them. So you can put in some additional controls if the user leaves one msgbox empty. If both the fields are not filled, the macro will give an error.

Regarding blank text boxes, you can use this as a check point first -

Please Login or Register  to view this content.

Thank you for the rep.

You can now mark this thread as solved.

pardon me if i'm wrong. not good with codes. should zbor's code have an INT to it so that an entry of 21st Dec 2012 12:45 pm be also taken in if user inputs:
20 Dec 2012
to
21 Dec 2012
so:

Please Login or Register  to view this content.