+ Reply to Thread
Results 1 to 4 of 4

Foreach Name in a List Paste a Template of Cells

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Denver
    MS-Off Ver
    Excel 2010
    Posts
    24

    Foreach Name in a List Paste a Template of Cells

    How would i make a script that says for each name in a list in WorksheetB than a premade template of cells gets pasted into WorksheetA. So if there is 7 names on the list than there should be 7 of this cell template pasted in a vertical fashion.

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Foreach Name in a List Paste a Template of Cells

    upload a sample workbook, i have no idea to what you are referring when you say "template of cells", the rest is easy to accomplish

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    Denver
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Foreach Name in a List Paste a Template of Cells

    Book1.xlsx

    I hope you get what i am saying. Let me know if you still need a better explanation or example. I tried to whip this up before i leave work.

  4. #4
    Registered User
    Join Date
    05-23-2013
    Location
    Denver
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Foreach Name in a List Paste a Template of Cells

    Any update?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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