Hi,
I don't really know anything about programming or VBA, but I am trying to learn.
Right now, I have a column that has data in it from a vlookup. I'd like to copy and paste this vlookup equation/code into the next column but change the range and one of the numbers for the whole column. I don't want to have to do this manually. Is there a way to automate this?
=VLOOKUP(Sheet1!B2,'TI Stats 2000-2015'!$A$20:$AV$28,3,FALSE)
I want that in the second column, but I want B2 to remain the same and to carry down like B3 on the next row, etc. And, I want the range to go from A34 to A42 instead. And, I want to change the number 3 to a 5.
Is there a way to do this quickly? And is there a way too repeat it for the next column where I will change the range yet again and change the 5 to an 8?
I don't really know anything about programming or VBA, but I am trying to learn.
Right now, I have a column that has data in it from a vlookup. I'd like to copy and paste this vlookup equation/code into the next column but change the range and one of the numbers for the whole column. I don't want to have to do this manually. Is there a way to automate this?
=VLOOKUP(Sheet1!B2,'TI Stats 2000-2015'!$A$20:$AV$28,3,FALSE)
I want that in the second column, but I want B2 to remain the same and to carry down like B3 on the next row, etc. And, I want the range to go from A34 to A42 instead. And, I want to change the number 3 to a 5.
Is there a way to do this quickly? And is there a way too repeat it for the next column where I will change the range yet again and change the 5 to an 8?
