jski21
Board Regular
- Joined
- Jan 2, 2019
- Messages
- 153
- Office Version
- 2016
- Platform
- Windows
Good day all,
Trying to run a macro from a command button on one tab (Tab 1) to transform data on another tab (Tab 3). Conducting a VLOOKUP from Tab 3 into Tab 1 and then autofilling the data down with this code:
Sheets("Tab 3").Range("D2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP([@User],Tab 1!C[4]:C[6],3,FALSE)"
Range("D2").AutoFill Range("D2:D" & Range("C" & Rows.Count).End(xlUp).Row)
Seems right but after executing the 3rd line to autofill the VLOOKUP, nothing happens. Column C is completely full. What gives?
Thanks!
jski
Trying to run a macro from a command button on one tab (Tab 1) to transform data on another tab (Tab 3). Conducting a VLOOKUP from Tab 3 into Tab 1 and then autofilling the data down with this code:
Sheets("Tab 3").Range("D2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP([@User],Tab 1!C[4]:C[6],3,FALSE)"
Range("D2").AutoFill Range("D2:D" & Range("C" & Rows.Count).End(xlUp).Row)
Seems right but after executing the 3rd line to autofill the VLOOKUP, nothing happens. Column C is completely full. What gives?
Thanks!
jski