Import Data from multiple spreadsheets into seperate spreadsheets worksheet

**cablecrt** · 10-16-2008, 10:31 AM

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.

**ravishankar** · 10-16-2008, 02:01 PM

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

**cablecrt** · 10-16-2008, 02:51 PM

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!