Putting all the data on one sheet when it will really will be on 3 sheets
doesn't help that much.

--
Regards,
Tom Ogilvy

"sameer27p " wrote in message
...
the required format is in Sheet1.xls (highlighted in yellow)....i need
to pick the total of quantities from two sheets and insert them in the
Actual and Forecast rows as per the item number and transaction
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=623598
---
Message posted from http://www.ExcelForum.com/