I have two excel files.
one is called MAster and the other Rider.

In RIder I will be doing lookup on the MAster file.
Once the rider page is complete (with all the lookups) I would like t
be able to simply keep the values generated from the lookups withou
the formulas.

the reason is that I would send the Rider file to an indivdual but
don't want to send the Master file.

I generate all my lookups using a Macro. Is it possible to dump to m
rider file only the values?????

I would then have to run my macro everytime I modify my Master file..

or can I have my Rider file with the lookup fomulas and run a macr
form there to generate another file with only the values???

thanks for any help

Pab

--
Message posted from http://www.ExcelForum.com