copy data in the date range

**delizoki66** · 06-01-2010, 05:06 AM

How to set a macro to copy data in the date range in sheet2, and so that each time before copying erase the previous data in Sheet2

**ebin charles** · 06-01-2010, 06:13 AM

Find attached file. Hope you satisfy.

Regards
Charles

**delizoki66** · 06-01-2010, 06:56 AM

In Sheet1 in unse various data to date events. They would automatically be copied when the fields B1 and B2 set the date in which the range should be copied to sheet2

**ebin charles** · 06-01-2010, 07:14 AM

I don't understand your second post.
Try to explain in correct.

Charles

**delizoki66** · 06-01-2010, 07:54 AM

The first sheet we use for data entry. In the first sheet when entering a date in the fields B1 and B2 determine the filter to copy into sheet2. I hope I can explain better upso. Sorry to worse English. Best regards