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 ?Is there any ready macro available for this ?
Thanks for your time and consideration...Attached:Sheet1.xls.....

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