Seperating a Workbook

[masonm27]

Created a workbook with 6 sheets. Due to access requirements to the document, I need now to split it up into 3 different workbooks. Each workbook will be housed in its own older, then sitting in a master folder (the folder structure permissions were easier to control in SharePoint). How do I break up the workbook and place it in the folders without breaking the formulas?

 

[RickXL]

If you don't have any macros then copy and paste should work.

Copy in all 6 sheets into every workbook then delete the ones you don't need.

Or are there formulas that will need to work across workbooks?