I multiple sheets with cells that are linked via lookup to another Workbk.
How do I expand the data range of the Vlookup without manually adjusting each
Vlookup formula.

My existing vlookup is something like this. =vlookup(c5,
OtherSheet!B5:J10,2,false) but now the data range from OtherSheet has
extended to B5:J99.

All help totally appreciated. I use Excel 2007. Thanks