+ Reply to Thread
Results 1 to 2 of 2

Create sheets from templates selected according to cell data

  1. #1
    Registered User
    Join Date
    08-16-2023
    Location
    USA
    MS-Off Ver
    2007
    Posts
    1

    Exclamation Create sheets from templates selected according to cell data

    Hello,

    Can anyone help in cranking out the VBA.

    I have a "Master" sheet with 2 columns : "TYPE" and "NAME" and I have a command button (ActiveX Controls) created and named it "CREATE SHEET"
    And, I have 2 other sheets namely "TEMPLATE A" & "TEMPLATE B".



    What I would like to do is:
    EXAMPLE:

    TYPE NAME
    A LP1
    B DP1

    So when I click, "CREATE SHEETS" button, I want Sheet LP1 to be created as per TEMPLATE A and Sheet DP1 created as per TEMPLATE B.

    If I enter a new TYPE and NAME in after creating sheets, it should only create the NEW data it detects and create only that sheet.

    Seems a lil complex. But i appreciate any help please.

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Excel VBA" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer
    Attached Images Attached Images
    Last edited by 6StringJazzer; 08-16-2023 at 02:25 PM. Reason: better titles please

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,625

    Re: Create sheets from templates selected according to cell data

    Try to attach a sample workbook.
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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