incorporate paste value in vlookup

  • Thread starter Thread starter bigproblem
  • Start date Start date
B

bigproblem

is there a way to incorporate "paste value" in a vlookup formula ? I have the
vlookups in the column working and feeding off of the multiple worksheets.
the data will be updated weekly (and new columns with the updated data added)
and i would rather just copy new data on top of the old in the worksheets
instean of having to add new worksheets with new data... as to keep the
previous column from changing.
 
Maybe you could record a macro when you do your own copy|paste special|values?

Then just rerun that macro when you want.
 
Back
Top