How to create multiple sheets and link data

**JOHNAK27** · 04-30-2013, 09:32 AM

Hi all
I have a workbook with 100 columns and 60 rows of data.
I want to split the data into 10 sheets in a new workbook with data linked,
.ie. sheet 1- first 10 columns with 60 rows,
then, sheet 2 - next 10 columns with 60 rows etc.
Is there a way I can do it without having to manually create all sheets & then paste link section by section b/w workbooks
I am using Excel 2010.
Many thanks, John