Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    157

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

    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

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If...Then...Else sounds like the answer...
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •