> Hi list! > > Not an expert in MS Excel but.... I have a list of customer numbers in a > spreadsheet, a customer master list on the second and I want to add all > the matched records on a third spreadsheet. > > How I do that? > > > Peter Vidal Well... I'm on the air with POI HSSF :-) Read the first sheet to a workfile (a) on iSeries Read the next sheet to a workfile (b) on iSeries Old fashion way: RPG prog. with MR (matching record) New fashion way: RPG prog. with chain from (a) to (b) If match/hit write down the matching record to the third sheet. Down on earth: I have contacted an expert in Excel-friend with your question. Hope to come up with something tomorrow. I'll let you know. Leif
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.