Results 1 to 4 of 4

Loop through list, saving template file as different names

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Wiltshire, England
    MS-Off Ver
    MS 365
    Posts
    84

    Loop through list, saving template file as different names

    Hello,

    I have a list of Counties in column A with their region listed in column B. (see attached example file).
    All 17 files are structured the same, so when I change anything, I need to change all 17 files.

    When I update my master file, I save it, but then I want to make 17 file copies of it as per below.

    Update cell F1 to the name of the first county in column A.
    Update cell F3 to the name of the first region in column B.
    Then save the file with the save name being the first county name in column A.

    Update the cell F1 to the name of the second county in column A.
    Update cell F3 to the name of the second region in column B.
    Then save the file with the save name being the second county name in column A.

    And so on, looping through the whole list in column A and B.

    So its a looping save macro that I require if you can help.
    Thanks very much.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering a list in excel then saving into a PDF with different file names
    By aexcelv in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-24-2018, 11:07 PM
  2. Replies: 1
    Last Post: 11-13-2017, 01:36 AM
  3. Replies: 11
    Last Post: 08-23-2014, 01:28 PM
  4. [SOLVED] Trying to Simplify Saving a file from A template
    By ThunderGod in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2012, 09:30 PM
  5. CSV file created from template is not saving to same location as the template.
    By SGALLAG1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2012, 11:26 AM
  6. Saving:template file
    By burgerboy2k6 in forum Excel General
    Replies: 0
    Last Post: 03-03-2007, 09:18 PM
  7. [SOLVED] Re: Saving template as non executable file
    By CodeBanger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2005, 09:05 PM

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