incorporate paste value in vlookup

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.
 
D

Dave Peterson

Maybe you could record a macro when you do your own copy|paste special|values?

Then just rerun that macro when you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with a vlookup 2
VBA Coding Help for Beginner 0
Copy compare worksheets 1
Embed the same Excel multiple times 0
VLookup Function HELP 7
New computer, how do i move outlook 365 ENTIRELY? 0
How to update a value from a linked worksheet back to the master worksheet? 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3

Top