Convert a tabbed worksheet into separate files

  • Thread starter Thread starter John G.
  • Start date Start date
J

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
 
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
 
Back
Top