Hi,

I have a workbook with 3 sheets in it. middle sheet has table of values,
which i want to export as a new workbook having only 1 sheet(that sheet) &
this new workbook must be named as old workbook & sheet should have just the
table formats & values, no Formulas.

Also, wanted to add, if there is a way to export new worksheet as new
workbook, with old name & delete the old workbook simultaneously, to save
space in hard-disk.

Any help would be most appreciated!

Rgds,

Eijaz