Thanks Mike. This is helpful. I will implement and test.

Regards,
Jackie

"Mike H" wrote:

Jackie,

If you have a vlookup on sheet 2 looking at sheet 1 such as

=VLOOKUP(A2,Sheet1!A$1:B$15,2,FALSE)

Deleting a row in iin the range A1 to B15 wont change the formula.

However, if you use

=VLOOKUP(A2,myrange,2,FALSE)

The myrange in the formula shrinks/expands as you add/delete rows.

Mike


"Jackie" wrote:

If you delete a row in a master worksheet can you program VLOOKUP to also
update the linked worksheets?