+ Reply to Thread
Results 1 to 4 of 4

Import Data from multiple spreadsheets into seperate spreadsheets worksheet

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    Toronto
    Posts
    2

    Import Data from multiple spreadsheets into seperate spreadsheets worksheet

    What I am trying to accomplish using a VB macro/coding is the following. I have two spreadsheets, the first is a "Template" spreadsheet that is filled out and contains a worksheet that collects raw data. The second spreadsheet acts as a "Consolidation Script" which pulls the raw data from a worskheet in the "Template" spreadsheet.

    There are multiple "Template" spreadsheets each month that get saved with distinct filenames and are all located in the same folder as the "Consolidation Script" spreadsheet. I want to use the "Consolidation Script" spreadsheet to pull all of the raw data together from the multiple "Template" spreadsheets into a single worksheet in the "Consolidation Script" spreadsheet.

    I've attached a screenshot to display what the "Template" spreadsheet raw data worksheet looks like. Thanks in advance for any assistance.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    762

    macro

    Hi
    Save this file in the same folder as raw data and run the macro
    Ravi
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-16-2008
    Location
    Toronto
    Posts
    2
    Thanks for the quick response Ravi. I tried running the macro and I get a Run-time error '13': Type mismatch error message. I went in to Debug and the line in question is:

    Please Login or Register  to view this content.
    I tried changing the worksheet name to match thinking that may have been the problem, but no success. The macro you wrote seems to be what I am trying to accomplish though, so you have me on the right track!
    Last edited by VBA Noob; 10-16-2008 at 02:52 PM. Reason: Added code tags as per forum rules

  4. #4
    Registered User
    Join Date
    10-15-2008
    Location
    Spencerport NY
    Posts
    9
    Do you need to put a dot value or dot formula after the Cells reference?

+ 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. Using a cell on another worksheet as input for data validation
    By gessie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2008, 09:53 AM
  2. Copying data worksheet to worksheet
    By fallito in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2008, 11:40 PM
  3. group data from multiple worksheets into a seperate workbook
    By ashlegg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2008, 06:30 AM
  4. Creating reference to array which has range defined in a seperate worksheet
    By cdrwolfe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2008, 09:02 PM
  5. How to move specific data from one worksheet to another worksheet
    By treeskin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2007, 02: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