THANKS TOM...BUT I REALLY NEED SOMETHING SPECIFIC....HOPE U CUD HELP M
IN DOING THAT...
the required format is in Sheet1.xls (highlighted in yellow)....i nee
to pick the total of quantities from two sheets and insert them in th
Actual and Forecast rows as per the item number and transactio
date......also,i need to calculate variance (ACTUAL-FORECAST)......

Can u help me in this ? Thanks for your time an
consideration...Attached:Sheet1.xls.....

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