Convert a tabbed worksheet into separate files

[John G.]

I have a workbook with about 10 tabs of different
worksheets. The worksheets have some formulas between
them. I need to separate the worksheets into separate
files and retain the formulas if possible.

Thanks

 

[Paul Corrado]

John

Right click on each tab and select move or copy. Move the sheets to a "new
workbook" then save that workbook. Formula references should remain intact.
Leave all of the files open until you have completed the task. Also, it
would be a good idea to back up the file just in case. (Open it then use
Save As to save under a new name.)

PC