+ Reply to Thread
Results 1 to 1 of 1

How to create different files from the data

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    268

    How to create different files from the data

    Hello friends.

    PFA the sample files.

    There are 2 input files.
    In the respective input files, we need to filter on "States".
    Paste the data in the out files in the respective tabs.

    Is there any macro which can help me.

    The data is huge and manually doing this excercise is very time-consuming.

    Could you please assist ?

    Input files :
    Input GST data Gold Mar 22.xlsb
    Input GST data HR Mar 22.xlsb

    Output required in files:
    Output Gujarat GST Mar 22.xlsx
    Output Madhya Pradesh GST Mar 22.xlsx
    Output Maharashtra GST Mar 22.xlsx

+ 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 new tabs (or files) from data
    By Allan863 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-13-2020, 04:31 PM
  2. Splitting out data to create multiple files
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 48
    Last Post: 07-02-2018, 04:20 PM
  3. Create two files depending on data
    By mklindquist0815 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2016, 09:13 AM
  4. How can I create multiple files from a series of data?
    By ccarmichael in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2015, 01:27 PM
  5. Replies: 2
    Last Post: 08-18-2014, 08:39 PM
  6. [SOLVED] Create CSV files from other CSVs and copying data
    By funkydim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2012, 11:07 AM
  7. Automating data import from multiple xls files to create 1 data source.
    By Anthem12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2012, 05:00 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