Every month I run a report whereas the table size changes. I need to be able to account for that.
I recorded this:
I need to have it update dynamically.
I found this (modified for my needs), but I'm not sure what to put in the "?" fields. Hopefully I'm on the right track:
I'm just not sure what R3C1:R35C33 is pointing at. Do I even need the above code or could I just update to R3C1:R350C33 as the row count should never get higher than 350. I'm assuming that is the row count.
Thanks.
I recorded this:
Code:
<code>Range("B1").FormulaR1C1 = _
"=IF(VLOOKUP(RC1,sorted!R3C1:R35C33,8,FALSE)="""","""",VLOOKUP(RC1,sorted!R3C1:R35C33,8,FALSE))"</code>
I found this (modified for my needs), but I'm not sure what to put in the "?" fields. Hopefully I'm on the right track:
Code:
With Worksheets("Move to New")
<code>.Range("B1").Offset(x, 0) = Application.WorksheetFunction.VLookup( _
.Range("?").Offset(x, 0), _
Worksheets("sorted").Range("?", .Range("?").End(xlDown)), 8, False)</code>
I'm just not sure what R3C1:R35C33 is pointing at. Do I even need the above code or could I just update to R3C1:R350C33 as the row count should never get higher than 350. I'm assuming that is the row count.
Thanks.