I have some data that I update every week. I use a macro to update
this data. The macro moves the old data down one row and copies the
new data from various places and pastes it to the top row of my table.
On some other sheets I have vlookups that reference this table. Each
time that I run my macro to update my table the vlookup also updates
and shifts my range down a row....

For example
=VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E
$501,1,False)

How can I stop the VLOOKUP Range from updating each time I run my
macro?

=VLOOKUP($A$4,$E:$E,1,False)

--
Regards,
Tom Ogilvy



"Matt.Russett" wrote:

> I have some data that I update every week. I use a macro to update
> this data. The macro moves the old data down one row and copies the
> new data from various places and pastes it to the top row of my table.
> On some other sheets I have vlookups that reference this table. Each
> time that I run my macro to update my table the vlookup also updates
> and shifts my range down a row....
>
> For example
> =VLOOKUP($A$4,$E$10:$E$500,1,False) becomes =VLOOKUP($A$4,$E$11:$E
> $501,1,False)
>
> How can I stop the VLOOKUP Range from updating each time I run my
> macro?
>
>