Sub Makro1() ' ' Makro1 Makro ' Makro zaznamenané 20.08.2016, Marcel ' ' ActiveCell.FormulaR1C1 = "meno1" Range("B2").Select ActiveCell.FormulaR1C1 = "vek1" Range("C2").Select ActiveCell.FormulaR1C1 = "pohlavie1" Range("D2").Select ActiveCell.FormulaR1C1 = "výška1" Range("E2").Select ActiveCell.FormulaR1C1 = "váha1" Sheets("tabulka").Select ActiveCell.FormulaR1C1 = "=databáza!RC" Range("B2").Select ActiveCell.FormulaR1C1 = "=databáza!RC" Range("C2").Select ActiveCell.FormulaR1C1 = "=databáza!RC" Range("D2").Select ActiveCell.FormulaR1C1 = "=databáza!RC" Range("E2").Select ActiveCell.FormulaR1C1 = "=databáza!RC" Range("E3").Select End Sub
Užitočné (2) | juriss, Terezia13 |
Excel automatické doplnenie údajov z databázy