Hi All,

I spool two oracle reports and get the data.this data is exported to
two excel files.then i put both the excel sheets into one workbook(RM
and PI) are the two sheets..
i now want to generate the model shown in the sheet.
the basic purpose of generating this model is to forecast the
consumption of parts.these two reports will be run every week..the
appropriate total quantity values need to be picked up from the two
sheets and displayed under the proper transaction date range for the
items common in both sheets......

can anyone please help me in this ?

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