You can use a named range in your Vlookup table that refers to the range of
the external data. Then use a macro to adjust the named range based on the #
of rows in the external data. You can use the special cells / last cell row
# to determine what row to go through (assuming the data starts in row 1).

"Excels Cracking me up!" wrote:

When i transfter data from an external source, I have formulas that pick up
the data from a Vlookup table, to match the transfered data, and return
various things.... the problem is, is that the transfer data is not always
the same amount of rows every day. To ensure i have calculated all the data
transfered, i have used the cheats way out and copied the formulas all the
way down to the bottom (Well 30000 cause i give up). Excel seems to struggle
with calculating cells all the time.... I know this is the wrong way of doing
it and i need to use some thing like Dynamic Data Ranges??? Ive looked into
it but to be honest i havent got the time to nerd around... im struggling to
understand the =OFFSET($A$1,0,0,MATCH("*",$A:$A,-1),1) formulas that i have
found, dont know where to input them etc... i thought i was quite good on
excel until this one! im going mad please help!
Thanks