Create multiple workbooks with variable number of sheets from existing workbook with multiple sheets

[sudarshan]

Hi,

I have a workbook with 7 - 8 sheets (number of sheets can change).Each sheets contains variable number of rows and columns of data with data starting A1 (header). I am looking for a way to split the workbook basis data in column A of 1st sheet and renaming the workbook basis that cell value. All the other sheets should also contain same row data as in 1st s
sheet.
If splitting the workbook is to be done on only one sheet, I am able to do but in this case wherein I have multiple sheets don't know how to go forward. Request if any one can help me in doing this.

 

[sudarshan]

hi,

anyone please help.

 

[ElmarvanLoon]

Hi, I might want to follow this question. I think I have a similar one.

Do I understand it correctly that you are also searching to split a workbook with multiple sheets into different workbooks where one sheet is leading and split while the other remaining sheets in the workbook are also copied to the splitted workbook (including reference to the splitted sheet)?