View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default vlookup - removing formulas

Hi,

copy then paste special, values

Regards!
Jean-Guy

"Megan" wrote:

I have used a vlookup to transfer data from spr 1 to spr 2. The problem is
that I want to now remove the VLOOKUP formulas from spr 2 so I am just left
with the data. How can I do this?
--
Kind regards
Megan