+ Reply to Thread
Results 1 to 3 of 3

VBA help to create new files with data and save as individual files with specific names

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    california
    MS-Off Ver
    office 2013
    Posts
    1

    VBA help to create new files with data and save as individual files with specific names

    Hi All.. excel vba request.jpg

    I am trying to find a way to create individual files with monthly activity for each brand and save it.

    There is a specific inventory report format we use that has our address and date see attached inventory report.jpg

    I just need a figure out a way to take the massive sheet with all of the data and break it down to individual sheets.

    currently its all copy paste manually . Could use your help to figure out how best to expedite the process by using a macro .

    tried doing it with recording the macro but it does not seem to do all of the name changes and or set the page break to fit within one page of landscape mode.

    thanks for your help.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2301 (Build 16012.20000) Win 11 Home 64 Bit
    Posts
    22,324

    Re: VBA help to create new files with data and save as individual files with specific name

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-18-2014
    Location
    california
    MS-Off Ver
    office 2013
    Posts
    1

    Re: VBA help to create new files with data and save as individual files with specific name

    apologize.. and please see attached files.

    both the individual file 5 points and the master file attached.
    Last edited by spawn23; 08-19-2014 at 07:11 PM.

+ 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. Create individual files from a row
    By GrahamN in forum Excel General
    Replies: 5
    Last Post: 07-13-2017, 03:28 AM
  2. [SOLVED] Macro help: create, edit, and save 200 files from list of names
    By mkbruin in forum Excel General
    Replies: 7
    Last Post: 12-18-2012, 03:27 PM
  3. [SOLVED] Creating a Macros to save individual columns as text files
    By lorigies in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2012, 05:18 PM
  4. How to save specific data into multiple files
    By stijndriessen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2011, 08:03 AM
  5. save many worksheets as individual csv files?
    By applegatecz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2010, 03:58 PM

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