urgently required..

[debra2468]

Hi All,

I spool two oracle reports and get the data.this data is exported t
two excel files.then i put both the excel sheets into one workbook(R
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 th
consumption of parts.these two reports will be run every week..th
appropriate total quantity values need to be picked up from the tw
sheets and displayed under the proper transaction date range for th
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=63823

 

[debra2468]

does no one have a solution to this ? if not a macro,any other way o
doing this ??????????