Create Sheet and Print Headings with the help of a code

**RAJESH SHAH** · 10-03-2022, 04:06 AM

Hello code experts
I am trying to create a new sheet with headings in the workbook. There is no masters sheet in the workbook. I want the code to create the master sheet first and then give the headings as shown in the expected sheet. The expected result sheet is attached for your reference. The code in the workbook is just for my testing and of course it doesn't work.

**JohnTopley** · 10-03-2022, 04:54 AM

Please Login or Register  to view this content.

"Master" is first sheet

**beyond Excel** · 10-03-2022, 05:59 AM

Hello. Practically the same as John but it is created as the last sheet of the workbook.

Please Login or Register  to view this content.

**RAJESH SHAH** · 10-03-2022, 08:21 AM

Awesome. Both the codes are accurate. Once this project is over, I can re arrange the sheets as I want in the end with the help of a code.
Thanks John Topley. Thanks beyond Excel.

Create Sheet and Print Headings with the help of a code

LinkBack

Thread Tools

Rate This Thread

Display

Create Sheet and Print Headings with the help of a code

Re: Create Sheet and Print Headings with the help of a code

Re: Create Sheet and Print Headings with the help of a code

Re: Create Sheet and Print Headings with the help of a code

Thread Information

Users Browsing this Thread

Similar Threads

Macro to compare Headings in all sheets and create a Result sheet for same and Differences

[SOLVED] Transfer data with Horizontal headings to sheet with vertical headings

[SOLVED] Setting Print area with VBA code on active sheet - Can't get my code to work

VBA code to have print button and print the required area in sheet.

[SOLVED] Macro to Create a Master Sheet and consolidate data as per Headings on all Sheets

[SOLVED] Create A New Sheet Within the Same Workbook and Add Headings

Trying to create a new sheet based on column headings selected

Bookmarks

Bookmarks

Posting Permissions