I have a workbook with many different worksheets in them. Each workshee
is a different trader and contains their trades for the day. I hav
created (with your help) a macro that will save the separate worsheet
to files and then email them to the individual traders. My problem i
that once they receive the email the sheet is looking for data from th
main sheet. Is it possible to take a “copy” of the worksheet and not th
actually formulas that give the data? If not how do you do this

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=26901