If you are using xl2003, what about saving as XML?

You could then open it and copy the information over to your new workbook.

--
Regards,
Tom Ogilvy


"rtheissen" wrote:


Hey all,

Big fan of this forum. I've been trying to figure out what the
simplest way to export data from 2 specific sheets and manage to save
the formulas and comments to like a .xls file then be able to reimport
them. the worksheets are called "Data" and "Loss Analysis Data" I'd
like to be able to save those 2 sheets to a file (we work with many
different accounts) then import those files. So far everything I've
tried has screwed up the dates or formulas. Anyone have any ideas?


--
rtheissen
------------------------------------------------------------------------
rtheissen's Profile: http://www.excelforum.com/member.php...o&userid=36164
View this thread: http://www.excelforum.com/showthread...hreadid=559475