help with Dates in VBA

[divuraj]

Hi,

In sheet 2 of my work book in a4 4 range , I have all the months ( not necessarily in the order) in 7/6/2007 format . i have values in sheet1 for a month and the month again is on cell G6 in 7/6/2007 format and i have values in G12:G17.

now i need to check the month in sheet1 and for the same month in sheet 2 , i need to copy values from G12:G17 from sheet 1 and paste them in K6:K11 in sheet 2.

i tried using For each statement and also input box from the user which would ask from teh user the month like "Dec-07" but it is not working.

Please help.

regards,
divs

 

[schielrn]

Could you possibly post the code as you have it right now?