Needs help to pull data from excel file and put it into new excel file

A

Anna

Hi: Can any one please tell me how to I create an output excel file
which values are comminig from another excel files.

ExcelFile1 Column Q = New file Column A
ExcelFile1 Column C = New file Column B
If ExcelFile1 Column I = ACH then new file column C = PMT
If ExcelFile1 Column I = CCD then new file column C = PMT
If ExcelFile1 Column I = BCK then new file column C = ERR
If ExcelFile1 Column I = CHK then new file column C = PMT
If ExcelFile1 Column I = CPB then new file column C = PMT
If ExcelFile1 Column I = CRT then new file column C = PMT
If ExcelFile1 Column I = CSH then new file column C = PMT
If ExcelFile1 Column I = DBK then new file column C = PMT
If ExcelFile1 Column I = DIR then new file column C = PMT
If ExcelFile1 Column I = EFB then new file column C = PMT
If ExcelFile1 Column I = EFT then new file column C = PMT
If ExcelFile1 Column I = LGL then new file column C = PMT
If ExcelFile1 Column I = MGR then new file column C = PMT
If ExcelFile1 Column I = MON then new file column C = PMT
If ExcelFile1 Column I = NGC then new file column C = PMT
If ExcelFile1 Column I = OAP then new file column C = PMT
If ExcelFile1 Column I = PCK then new file column C = PMT
If ExcelFile1 Column I = PMO then new file column C = PMT
If ExcelFile1 Column I = PYM then new file column C = PMT
If ExcelFile1 Column I = QCT then new file column C = PMT
If ExcelFile1 Column I = RDP then new file column C = PMT
If ExcelFile1 Column I = WRT then new file column C = PMT
ExcelFile1 Column J = New file Column D

New file Column E = Query
I dont know how to i pickup ExcelFile1 Column Q which is equals to
b.clt_ref_no and get value a.check_no in column E
select a.check_no,b.clt_ref_no,b.debt_id from pmt a inner join debt b
on a.debt_id=b.debt_id where b.clt_ref_no='6000221454'
Basically if there is a value in field a.check_no then it print that
value otherwise it print OX in column E

If New File Column A = ACH then new file column F = 16
If New File Column A = BCK then new file column F = 11
If New File Column A = CCD then new file column F = 3
If New File Column A = CHK then new file column F = 1
If New File Column A = CPB then new file column F = 1
If New File Column A = CRT then new file column F = 6
If New File Column A = CSH then new file column F = 7
If New File Column A = DBK then new file column F = 19
If New File Column A = DIR then new file column F = 8
If New File Column A = EFB then new file column F = 17
If New File Column A = EFT then new file column F = 16
If New File Column A = LGL then new file column F = 9
If New File Column A = MGR then new file column F = 2
If New File Column A = MON then new file column F = 2
If New File Column A = NGC then new file column F = 20
If New File Column A = OAP then new file column F = 11
If New File Column A = PCK then new file column F = 1
If New File Column A = PMO then new file column F = 2
If New File Column A = PYM then new file column F = 15
If New File Column A = QCT then new file column F = 4
If New File Column A = RDP then new file column F = 1
If New File Column A = WRT then new file column F = 16
 
Top