Cell C1 contains a date.Macro to check the date in C1, 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.Also copy a6 column downwards to sheet2, cell a3.
A:
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.
AMissico
2010-06-09 02:24:48
I have gotten way pass that, Thanks.
Angela
2010-06-09 10:11:16
A:
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.
datatoo
2010-09-13 16:24:36