Copy and paste column data based on date specified

In an Excel work开发者_如何转开发sheet, cell C1 contains a date. I would like a macro that checks the date in C1 and if the same date is mentioned in row 3, then copy all matching date data beneath it from D6 downwards, paste to Sheet2, cell B3 and also copy column A downwards from row 6 to Sheet2, cell A3.

---

Use Excel's macro recorder to record your keystrokes and mouse actions (as Excel actions) then inspect the resulting macro. Using Excel's help, check the topic Create a macro or visit http://office.microsoft.com/en-us/excel-help/create-a-macro-HP005204711.aspx. This will get you started.

---

are you checking the date in C1 against any column in row 3? or in D3? or C3? It is not clear. copy A6 down and D6 down, but switch column D to B on sheet2 and A to C on sheet2?

This could be easy if it were clearer what you are checking.