I work with spreadsheets a lot for my expediting position. Tracking lead
times. I am creating a status spreadsheet that has to pull information from
several other spreadsheets as one report does not provide all information.
Right now, I simply cut and paste new information in "working" spreadsheets
and the formula is set to pull specific information (dates, quatities, etc.)
from these working sheets. The problem is when I cut and paste new
information, the Vlookup formulas always lose the table array information.
It keeps the "working" spreadsheet name, but, not the total information to
look in. Is there a constant that I can use in the formula, i.e. $ to keep
this from happening...?

--
Thanks!!
Shonte