Reference values from a table in VBA code

[#1]

Hi there

In my VBA code, I am trying to reference values in a specifc table. Can this be done? I need something like:

For each value of var1 in table T01

If var1 = 'New York' Then VBA_NY_Count = var2

Loop

AND THEN

if the row number in table T02 < VB_NY_Count then export row to Excel (or select and copy/paste to Excel)

Any suggestions or a starting point would be greatly appreciated!