Creating Table Format

[Excel God]

Hello Forum members,

I am currently working on an Excel Report to generate a summary of my weekly data entry.
The format is relatively simple, a Job Number at the top right hand side (e.g., ELL-CI-180510-00201) followed by the 15 column table. (The rows will vary based on the Job number).

So what i wish to accomplish is based on the example worksheet that I have attached, I wish to have a VBA command that can allow me to replicate the same exact table with everything intact (column headers, formulas) excluding the data on each row. So basically it will be a clean table format for me to work on.

And I also need the table to be generated based on my active selection.

[dflak]

This is something that should work for you. Map it to a control key of your choice.

The code prompts for a sheet name. It checks for invalid characters in the sheet name and substitutes an underbar, "_", if it finds one.

The code then copies the template sheet (which has the blank table in it) to a new sheet and names the sheet with the sheet name provided. The table on this sheet is "Table_" + the sheet name with any spaces in the sheet name replaced with underbars.

Please Login or Register  to view this content.