+ Reply to Thread
Results 1 to 4 of 4

pulling data from other excels , im new to vba :(

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    chile
    MS-Off Ver
    Excel 2003
    Posts
    3

    pulling data from other excels , im new to vba :(

    Hello , i need to create a master file that pulls data from others that have always the same Colums Format. The number of rows can change.
    Im attaching an excel wich contain what i need to do. The sheets name are the same in every file i have to pull info. The files names where i have to extract the information are for example "Caja "& "14-10-2014" (dont know if this is needed)
    What i want in the master file is all the transactions together in the same table. (the 2 sheets have different info , so i need 2 tables) The master file table has the same format as the files were i extract the info.example.xlsx
    Im still new with vba if someone can help me it will save me lot of time : )
    thanks

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: pulling data from other excels , im new to vba :(

    This free add-in may do what you need.

    RDBMerge, Excel Merge Add-in for Excel for Windows
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    03-14-2013
    Location
    chile
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: pulling data from other excels , im new to vba :(

    i dont know why the addin doesnt work im using excel 2013
    Last edited by whoisgg; 10-15-2014 at 02:42 PM.

  4. #4
    Registered User
    Join Date
    03-14-2013
    Location
    chile
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: pulling data from other excels , im new to vba :(

    plz if someone can help me :D

+ 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] Copy Data from a specific tab of Multiple Excels into one excel
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 01:40 AM
  2. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  3. Master report generation by pulling data from multiple excels(in specefic format)
    By ashwin_max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 12:54 PM
  4. VBA to create object specific excels based from the rolled up data
    By yelena in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2012, 05:27 AM
  5. Refresh SQL data link by macro instead of excels connection wizard
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-23-2010, 11:11 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