abhirupganguli123
Board Regular
- Joined
- Feb 25, 2014
- Messages
- 55
Hi,
I have a spreadsheet with 'N' number of columns. I want to create seperate worksheets based on a column data through a macro. Since I have many of such sheets with no fixed columns, so the macro should ask from which column I want to create sheets. I will give the column number (1,2,3 etc) and the macro will create new sheets in the existing workbook with data. The base data sheet will remain as the first sheet. I have other 4 criteiras -
1) The cell formats will be exactly same as the base data sheet.
2) The sheet names will be same as the column data.
3) If any description of the column data is too long for being a sheet name, then it will take maximum letters starting from first that a sheet name can have.
4) If the description of the column data has any symbol that a sheet name can not have (like "/"), then it will replace the symbol with a space while making the sheet name.
Can anybody please help me with such VBA code ?
Thanks,
I have a spreadsheet with 'N' number of columns. I want to create seperate worksheets based on a column data through a macro. Since I have many of such sheets with no fixed columns, so the macro should ask from which column I want to create sheets. I will give the column number (1,2,3 etc) and the macro will create new sheets in the existing workbook with data. The base data sheet will remain as the first sheet. I have other 4 criteiras -
1) The cell formats will be exactly same as the base data sheet.
2) The sheet names will be same as the column data.
3) If any description of the column data is too long for being a sheet name, then it will take maximum letters starting from first that a sheet name can have.
4) If the description of the column data has any symbol that a sheet name can not have (like "/"), then it will replace the symbol with a space while making the sheet name.
Can anybody please help me with such VBA code ?
Thanks,