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
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
