copy selected cells in a row/s to another worksheet based on date-VBA

[dibyendu]

Hello,

I need to copy data from worksheet "Records" to worksheet "Reviews" based on date (msg. box= which date?).
In worksheet "Records" date is in column "BV". I need to copy column "C", "D","BU", "BV","BW", "BX" from worksheet "Records" when particular date of interest matches and paste it to column "A", "B", "C", "D", "E", "F" of worksheet "Reviews"(The first row should remain blank for adding "Headings"). Evey time when VBA runs the previous data in worksheet "Reviews" should be clear(delete). The VBA code needs to search from 10,000 rows from worksheet "Records". I am new to VBA and need your support. Thanks for your support.

 

[Fluff]

What is the standard date format where you live?

 

[dibyendu]

In my data the format is "MM/DD/YYYY"

 

[Fluff]

Is that the standard format in your part of the world?
If you select a cell with a date (eg today) 8/17/2017 what does it say in the formula bar, rather than the cell?

 

[dibyendu]

In the formula bar it say "9/17/2017" (eg for today).

 

[Fluff]

In that case my code from post#9 should work, as long as the dates are real dates.
Check that the code your using has this

.AutoFilter Field:=1, Criteria1:=Mydate

If it does, select col BV & format as text. Do you see numbers like 42995?

 

[dibyendu]

It shows number 42996

 

[Fluff]

In your code is the criteria1 in the autofilter the same as I've got in post#15

 

[dibyendu]

Then what will be the solution

 

[Fluff]

Glad we got it sorted & thanks for the feedback

 

[dibyendu]

https://drive.google.com/file/d/0B3mCr8NTh3hRTHVWUmMzV2JuaEk/view?usp=sharing
I have attached my excel sheet as "sample". This may solve the problem.