Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    trasfer range line with a condition.... (2000 r s1)

    I would want to transfer range of line (G:I:J:L:M:AB:AC) from A.T. Campania to the sheet STORIA, but during the transefering of range "transcode" with the table in range I3:J9 orf sheet STORIA, the value fom A.T. Campania for column J and M to STORISA column C...

    Example:

    cell J3 of A.T. Campnia sheet contain RECUPERO RATEALE transcode during the transfer to sheet STORIA in cell C3 with the code of table in this case "7"...

    cell M3 of A.T. Campnia sheet contain DEFINITA CON ACCREDITO transcode during the transfer to sheet STORIA in cell E3 with the code of table in this case "2"...

    ecc....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: trasfer range line with a condition.... (2000 r s1)

    Hi Sal,

    You should be able to write code to transfer columns G, I, J, L, M, AB and AC from A.T.CAMPANIA to STORIA (without recoding). Do this first, and test it to see that it works correctly.
    When you have done that, you can work on the recoding. You could use (for example) SELECT CASE ... EMD SELECT, or the worksheet functions MATCH and INDEX.

Posting Permissions

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