i have a question...

i have two reports which are spooled from Oracle.they are exported t
.xls files.

i bring the two excel sheets in the same workbook..
then i need to pick up values from the two sheets (RM and PI) and plac
them according to the transaction date accd to the date patter
generated.

the total quantities need to be picked from the two excel sheets fo
that particular item....

how do i generate such a pattern ? any idea ?

--
Message posted from http://www.ExcelForum.com

any one who has worked on such a report before...please help me..

--
Message posted from http://www.ExcelForum.com