+ Reply to Thread
Results 1 to 2 of 2

Looper within looper

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Looper within looper

    Hello and thanks in advance. I am trying to rebuild a looper I have a different way. Ignore the VBA code in the workbook currently because it is all changing. The File List tab is what I want to concentrate on. I want the template open a number of times (column A), I want the cells in B1 and C1 of the File List tab copied and pasted into he template tab called input cells c1 and c2. Then do a file save as close the new file then open the template again and move down to copy b2 and c2 and repeat over and over until it completes the full list. I have code to do the file save as. Just need help on the Loop within loop.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Looper within looper

    I think this is the basic idea.
    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. [SOLVED] Looper File That opens files from a list to paste values from a cell in a list
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2014, 10:49 AM
  2. cut and paste looper that looks at columns for ranges
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2014, 05:26 PM
  3. [SOLVED] looper to copy tabs of a data file into template and save as
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-26-2014, 10:47 AM
  4. [SOLVED] Looper blooper
    By Arne Hegefors in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2006, 10:25 AM
  5. [SOLVED] Looper Blooper
    By stendahl_jones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2006, 07:40 AM

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