Replicating the data in Excel

Here i have attached one excel sample template. If i pass tables names as a input to this template it should create different tabs for different table names. I have to automate this as i need to create different sheets for different groups. Let say if i am passing table names as "tracking","summary","sumry_enhmt" , it should create or copy standard template data into three tabs. Here i have attached expected output for your understanding.

Kindly help me here.

I don't see where you have placed the sheet names in your file. How will you indicate the particular sheet names and where?

You have not provided a location for the names you want. Without them physically located within a spreadsheet, there is no way to tell Excel to do what you want. I ask again, how will you pass the names to excel? Where are they located in your spreadsheet?

Give this a try:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button