Also, there may be times (although few) when I will need to pull two sheets
to a new workbook...can this be done via a macro?

"MGC" wrote:

I am looking for a macro to copy 1 worksheet from a workbook to a new
workbook. I would like to take this as far as the "save as" part so that the
user only needs to select it's destination. I will be adding this to
existing VBA code. Can this be done and how?