Hi,
I need to pick up values from two different sheets and put them unde
two rows (Actual and Forecast) as per the transaction date..Also i nee
to calculate the variance(actual-forecast).Is there a readymade macr
available for plucking values from two sheets and placing them in th
output sheet (i need the total value of each item in the two columns t
be picked up and displayed ),,,,,,,,,,,,,,,,,,,,,

does anyone have an idea how i can go about ? look forward to have
reply soon.thanks for ur time and consideration....refer Sheet1.xl
which specifies my requirement......

Attachment filename: sheet1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62244
--
Message posted from http://www.ExcelForum.com