LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Many Workbooks into one spreadsheet

Is it possible to do the following?

I have 12 separate spreadsheets in 12 workbooks that contain data in.
Some column names are common to all 12 (PLANT COUNTRY INDUSTRY TYPE
SURVEY RESPONDENT), other column names (different data) are only common
in some of the 12 and there are few column names not common but just in
one sheet.

Want to be able to merge the data from the 12 workbooks into one.


Appreciate your help on this.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding duplicate data between 2 spreadsheet workbooks? jonathan182 Excel Discussion (Misc queries) 4 April 19th 07 11:52 AM
Protecting Page Set in spreadsheet / workbooks JS Excel Worksheet Functions 0 September 2nd 06 01:45 PM
How can I create a master spreadsheet from different workbooks Dawn Williams Excel Discussion (Misc queries) 1 May 3rd 06 12:10 PM
Copy Workbooks and Paste into same spreadsheet lcannon Excel Programming 1 June 13th 05 08:38 PM
Adding a row in all workbooks within a spreadsheet ndpocohantas Excel Discussion (Misc queries) 3 April 22nd 05 09:23 AM


All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Đ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"