+ Reply to Thread
Results 1 to 18 of 18

Exporting data from master file to pre-populate many excel files from a template

Hybrid View

  1. #1
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Exporting data from master file to pre-populate many excel files from a template

    Just change that red color 4 to 17 and red color 3 to 5
            FR = 3
            FR1 = 4    fin = Array("L", "M", "N", "J", "K")
        For k = LBound(fin, 1) To UBound(fin, 1)
            .Range(fin(k) & j).Copy Workbooks("" & mybk & "").Sheets("Financials").Cells(FR1, FR)
            If FR = 5 Then
                FR = 3
                FR1 = FR1 + 3
            Else
                FR = FR + 1
            End If
    Please if you agree and satisfied with the solution then click on Add Reputation below to the post left side
    Last edited by Naveed Raza; 08-07-2013 at 07:13 AM.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

+ 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. [SOLVED] Auto copy data from other Excel files to master file...
    By NeoNirav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2013, 12:13 AM
  2. Vlookup query : How to pull data from raw excel files into a master excel file?
    By jamesjamesiata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2013, 06:26 AM
  3. [SOLVED] Import data from excel files to append master file
    By kdawgpl9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2013, 04:32 PM
  4. Macro to populate a word template and feed an excel master sheet
    By hieldy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2013, 05:40 AM
  5. Replies: 1
    Last Post: 03-13-2012, 09:45 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