Copy and paste selective rows of data from a user prompt

I have search this forum for macros / VBA but I cannot find a close similarity with what I need. Here is my scenario:

In my first column are dates. Now, I need a button to run a macro and this is what the macro needs to do:

1. Opens a message box prompting for the date he wants to COPY. The date must be from the ones listed in the first column. It can be in a form of FROM and TO selection.
2. The FROM and TO selection shall show the dates in the first column so that the user cannot enter an invalid date, like a Data Validation.
3. When the user selects the FROM and TO dates, the marco then copies the contents of cell ranges (specified in the FROM and TO selection) in columns C through D and pastes the data into columns I through J, also copies (in the same rows) the contents in columns E through F and pastes into L through M.

Here is a screen shot:
http://filesxpress.com/d-72c45cb2

In the screen shot above, if the user selects FROM as March 4, 2016 (A5) and TO as March 10, 2016 (A11), then the macro copies the range C5:D11 and pastes to I5:J11, copies E5:F11 and pastes to L5:M11.

The file is attached below.

http://filesxpress.com/d-cf2c89dd

I tried attaching the file but the attachment button is not working. I hope the links work.

Thank you for your help.

hope this helps you, it does assume everything is correct...if u want some testing, just drop some ifs

Please Login or Register  to view this content.

you need the other columns also...so add

Please Login or Register  to view this content.

inside the IF next to the other "Range" line.

Originally Posted by Arkadi

Here is another option:
it is a file for download since I too can't get the attachment button to work.
http://filesxpress.com/d-ec68c319

This version uses a simple userform with only dates contained in the sheet available for selection. It also makes the end date the same as the start date if it is not specified.

Nice form.

Originally Posted by zaonpt

you need the other columns also...so add

Please Login or Register  to view this content.

inside the IF next to the other "Range" line.

Hi, thank you for your input. It is working and it is simple. Though the entry for the FROM and TO dates are manual, I can follow your logic easily! Thank you very much for your help.

Originally Posted by Arkadi

Here is another option:
it is a file for download since I too can't get the attachment button to work.
http://filesxpress.com/d-ec68c319

This version uses a simple userform with only dates contained in the sheet available for selection. It also makes the end date the same as the start date if it is not specified.

Thank you very much for the solution. The form is indeed very nice and correct to the point that the user can pick the FROM and TO date as required.
However, in my actual work file (not the same as the sample file I uploaded or shared), I just copied (export and import) your FORM to my work file, copied the Module1 code, but when I click on the button, the Initialize part of the code gave an error:

Compile error: User-defined type not defined.

Maybe because my ACTUAL date column is in B12 to B42? And my dates are actually formulas and not plain dates? Please advise

Thank you for the quick reply. After the edits, the Compile error was gone. However, I got a runtime error:
http://filesxpress.com/d-4e6b35bb

When I click debug, Module1 code is shown and frm_dateselect.Show is highlighted in yellow.
Is this because my column B has no header?

Thank you.... The form indeed showed up, I was able to select the FROM and TO dates. But clicking COPY gave an error:

Please Login or Register  to view this content.

When I click Debug, the line highlighted in yellow is:

Please Login or Register  to view this content.

Nothing was copied, it just failed.
There are no blank rows in the middle.
The first row with data is B12

Thank you. It is now working but the data copied are wrong and the data are pasted in the wrong places. Maybe because of the actual structure of the data. I believe you can take a look at the actual file.

My goal is to copy the columns D through L and paste to AJ to AR and then copy columns X through AH and paste to AT through BD, starting from the row in START date and ending in the row in END DATE.

http://filesxpress.com/d-bcd7c40e

Thank you very much.

Originally Posted by Arkadi

I believe the problem with copying the data is that you are reading the code with the logic of "copy from a to b" where as my code's logic is b=a.... so try these 2 lines in the for loop on the commandbutton code:

Please Login or Register  to view this content.

Thank you!!!! It is now working!!! Thank you very much