Results 1 to 20 of 20

Automatically make new excel-files (and save in specific folder on my computer)

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Assen, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    9

    Automatically make new excel-files (and save in specific folder on my computer)

    Example data.xlsxCan someone help me with a good VBA-code for underlying problem?

    I have to save a lot of excel-files with different names. (about 100)
    I need a macro to automatically save excel-files with different names in a specific folder on my computer.

    See attachment.

    The name of the files should contain the combination of column G and H. (for example "1206 - Praktijkhuisman.xlsx")
    He should make a new file when there is an other unique value in Column G.


    After making a new excelfile he should copy the data (include layout) in a tab (with same name as the new excel file) from column A t/m L.
    Only the data for the Unique value in Column G.

    Please can someone help me??
    Attached Images Attached Images
    Last edited by Josvanderwaaij; 08-20-2014 at 06:03 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  2. one folder & so many excel files are save, i want name change without open excel files
    By sonu_kumar444 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2013, 03:45 PM
  3. Replies: 1
    Last Post: 01-24-2006, 11:35 AM
  4. Replies: 1
    Last Post: 01-24-2006, 11:00 AM
  5. Replies: 1
    Last Post: 01-24-2006, 12:25 AM

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