Results 1 to 2 of 2
2005-11-19, 10:55 #1
- Join Date
- Jan 2004
- 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...
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"...
2005-11-19, 11:04 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: trasfer range line with a condition.... (2000 r s1)
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.