+ Reply to Thread
Results 1 to 3 of 3

Master file to split into various existing templates

  1. #1
    Registered User
    Join Date
    02-24-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Master file to split into various existing templates

    Dears,

    I would like to copy from Master file and paste into multiple excel file.

    1. Copy from sheet 'Raw'
    2. Filter based on column 'H',
    3. This should be copy pasted into the filtered existing file name template with the sheet name 'Data' (Almost 50 Templates.

    Any help would be highly appreciated.

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    02-24-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Master file to split into various existing templates

    Dears,

    Not sure If my question was not clear. May I know if I can get help from anyone?

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Master file to split into various existing templates

    Hello ranr765 and Welcome to Excel Forum.
    It would be easier for someone to help if you could upload a small sample workbook that demonstrates what you are trying to accomplish. I would think that a 'Raw' sheet with a few rows of information and two 'Data' sheets showing how you want the filtered information to be displayed should be sufficient. You will need to be manually input the information on the 'Data' sheets, so that someone here will be be able to attempt to write formulas and/or VBA code that replicates the filtering process.
    To upload a sample workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Update existing macro that splits a list into worksheets to split into templates instead
    By Graeme-Black in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2014, 04:19 PM
  2. Macro Definitions - File Name Changes from Master Templates
    By bwsutton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2014, 07:34 AM
  3. Macro Definitions - File Name Changes from Master Templates
    By bwsutton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 11:32 AM
  4. Replies: 1
    Last Post: 10-24-2013, 01:05 PM
  5. [SOLVED] VBA Split Data and Move to targeted named file from master file
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2013, 01:06 PM
  6. Split data from Master Sheet to existing worksheets and overwrite data
    By vmwest in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-21-2013, 05:36 PM
  7. Split out worksheets then merge into master file
    By pixifaery in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2010, 06:59 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