I have a "destination" workbook that is linked to the "main" workbook using
SumProduct and Match. The problem is I can't email the destination workbook
to anyone who doesn't have the main workbook because they can't read it. Is
there some programming I could do that says paste values and formatting of
the destination workbook to another workbook and automatically save it using
the sheet name as the filename (or override if filename already exists) ? If
I can do this then I don't have to worry that no one has the main workbook.