+ Reply to Thread
Results 1 to 5 of 5

Repeated Worksheet Header creation from list of data

  1. #1
    Registered User
    Join Date
    09-06-2018
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Repeated Worksheet Header creation from list of data

    Hello, I'm trying to see if there is anyway to create a macro/VBA code to copy/paste data into a worksheet repeatedly. I have attached the file. On the Data tab each row represents a new sheet header I need to create. I do this by taking each row and copying it into the space in the "Header Populate" tab. This populates the appropriate data into the "Sheet Header" Tab. I would then create a copy of the Sheet Header tab and copy/paste values on it so I have running workbook of Sheet Headers to print. I would need to do this until the end of Data so it would create 17 tabs. Is there a way to write a Macro code to automate this? I would need it to create as many sheets as there are rows of data in the data tab so that I can do this in bulk. Any help would be appreciated. Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Repeated Worksheet Header creation from list of data

    .
    Do I correctly understand when the 17 tabs are created, each one will look like the image below with its own unique header info from the rows on the
    DATA TAB ? The image below is the top of the SHEET HEADER sheet.


    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    1
    2
    Test 1 Blank Test 2 Project 1 Blank Test 4 Test 5 Test 6 Test 7 Test 8 Test 9
    3
    4
    5
    6
    8
    9
    10
    Test 1
    Test 2
    Project 1
    11
    12
    14
    INVOICE INFO
    15
    16
    17
    Test 8
    18
    Last edited by Logit; 03-20-2019 at 09:30 PM.

  3. #3
    Registered User
    Join Date
    09-06-2018
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Repeated Worksheet Header creation from list of data

    Quote Originally Posted by Logit View Post
    .
    Do I correctly understand when the 17 tabs are created, each one will look like the image below with its own unique header info from the rows on the
    DATA TAB ? The image below is the top of the SHEET HEADER sheet.


    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    1
    2
    Test 1 Blank Test 2 Project 1 Blank Test 4 Test 5 Test 6 Test 7 Test 8 Test 9
    3
    4
    5
    6
    8
    9
    10
    Test 1
    Test 2
    Project 1
    11
    12
    14
    INVOICE INFO
    15
    16
    17
    Test 8
    18
    Yes. The unique header info from each row will populate each sheet header. So in this example there will be 17 sheet headers.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Repeated Worksheet Header creation from list of data

    .
    Paste this macro into a MODULE. Place a UserForm button on the SHEET HEADER sheet.

    Please Login or Register  to view this content.

    Note : The following section of the Copy_Sheets macro places the word TEST and the sheet number in cell Q15. You can edit the word "Test" to anything you require or you can
    delete both lines : Sheets(i).Name = "Test " & Nmbr ... Sheets(i).Range("Q15").Value = Nmbr: Nmbr = Nmbr + 1


    Please Login or Register  to view this content.
    Or, you could change the location from Q15 to a cell of your liking.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-06-2018
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Repeated Worksheet Header creation from list of data

    Quote Originally Posted by Logit View Post
    .
    Paste this macro into a MODULE. Place a UserForm button on the SHEET HEADER sheet.

    Please Login or Register  to view this content.

    Note : The following section of the Copy_Sheets macro places the word TEST and the sheet number in cell Q15. You can edit the word "Test" to anything you require or you can
    delete both lines : Sheets(i).Name = "Test " & Nmbr ... Sheets(i).Range("Q15").Value = Nmbr: Nmbr = Nmbr + 1


    Please Login or Register  to view this content.
    Or, you could change the location from Q15 to a cell of your liking.
    Hi, So I tried this and it didn't quite work, I looked at the sheet you attached and I think I may have miscommunicated. So when I hit copy all the row data show up in row 1 on each sheet for each row. However what I need for it to do is populate the yellow boxes with that data similar to if you just copied a row from the Data sheet into the "header populate" tab. You will see the project # change and some of the test data change slightly. I'm trying to speed up the process of having to just copy paste lines into that line on the "header Populate" tab. Let me know if that makes sense. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. List creation through Data Validation and Multi-Select?
    By kbenderil in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-03-2013, 03:12 PM
  2. [SOLVED] When filtering repeated data, leaving the title(header) alone without deleting it
    By exlgh91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2013, 12:58 PM
  3. [SOLVED] Macro To Highlight Repeated Data On Worksheet
    By SilverFox in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-20-2012, 04:58 AM
  4. Replies: 2
    Last Post: 10-13-2012, 03:30 AM
  5. Automated Worksheet Creation from Cell Data
    By davis8383 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2009, 10:33 AM
  6. Report creation from worksheet data
    By That_Girl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2007, 04:43 PM
  7. list with multiple repeated data
    By ArturoCohen in forum Excel General
    Replies: 1
    Last Post: 08-14-2006, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1