Sub cerca_ozz_seconda() ' ' cerca_ozz_seconda Macro ' seconda prova ' ' ActiveCell.Offset(-2, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "" ActiveCell.Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(3, 0).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=+HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=+HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveWindow.SmallScroll Down:=9 ActiveCell.Offset(3, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1:R2,11,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=HLOOKUP(RC[-1],[Aida_Export_3.xlsx]Risultati!R1C1:R2C14,2,)" ActiveCell.Offset(1, 0).Range("A1").Select End Sub Sub dati_2012() ' ' dati_2012 Macro ' ' ActiveCell.Offset(-11, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Select ActiveCell.FormulaR1C1 = _ "=+VLOOKUP(RC[-3],[dati_2012.xlsx]Risultati!R1:R2,7,TRUE)" ActiveCell.Offset(3, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(4, 0).Range("A1:B1").Select ActiveWindow.SmallScroll Down:=9 ActiveCell.FormulaR1C1 = _ "=VLOOKUP(R[-4]C[-3],[dati_2012.xlsx]Risultati!R1C1:R2C13,11,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(R[-5]C[-3],[dati_2012.xlsx]Risultati!R1C1:R2C13,13,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(R[-6]C[-3],[dati_2012.xlsx]Risultati!R1C1:R2C13,12,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(R[-7]C[-3],[dati_2012.xlsx]Risultati!R1C1:R2C13,10,TRUE)" ActiveCell.Offset(1, 0).Range("A1:B1").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(R[-8]C[-3],[dati_2012.xlsx]Risultati!R1C1:R2C13,9,TRUE)" ActiveCell.Offset(1, 0).Range("A1").Select ActiveWindow.SmallScroll Down:=9 ActiveCell.Offset(14, -1).Range("A1:C1").Select Selection.Copy Windows("scoring mcc.xlsx").Activate ActiveSheet.Paste Windows("mcc file.xlsm").Activate End Sub |