Thanks Jim Reinardy and Leif Guldbrand for your feedback! I was able to do it easily in MS Access and also by transferring the data up to the iSeries and simply do some queries over to prepare my report. I am still willing to know how to do it in Excel though. A friend told me that I can also use pivot tables but I need to practice... Thanks everybody! Peter Vidal PALL Corporation / SR Programmer Analyst, IT Development Group 10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111 http://www.pall.com "My religion consists of a humble admiration of the illimitable superior spirit who reveals himself in the slight details we are able to perceive with our frail and feeble mind." -Albert Einstein- (1879-1955)
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.