Search : in
By :

Collate data from multiple Excel files

Last answer on Sep 2, 2009 12:16:07 pm BST Archana, on Feb 9, 2009 5:51:51 am GMT 
 Report this message to moderators

Hello,

I want to select the range (K13:K25) from multiple excel files and add them in new columns in a new excel file.

Is there some way i can do this if i store all the required excel files in one folder?

Configuration: Office 2007

Best answers for « Collate data from multiple Excel files » in :
Converting a large excel file to PDF Show
Comparing and extracting data in Excel Show
Assembling multiple PDF files Show Assembling multiple PDF files Intro Steps: Intro PDF creator is a software allowing you to print several files into one with its printer function. Download link http://en.kioskea.net/telecharger/telecharger-40-pdf...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Excel – How to extract partial data? ShowExcel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
File formats and extensions Show
Ask your question Reply

1

alphadog, on Feb 9, 2009 8:47:08 am GMT
  • +5

Hi,
try this link to get help Microsoft:
office.microsoft.com/en-us/excel/FX100646961033.aspx
you may try this as well:
serc.carleton.edu/introgeo/mathstatmodels/xlhowto.html

   
Reply to alphadog

2

way2ashish, on Apr 23, 2009 9:54:04 am BST

Hi archana

did u managed to find the solution to the problem..
I am facing similar issues

   
Reply to way2ashish

3

Guest, on Aug 6, 2009 8:47:30 pm BST

Has anyone found a solution?
Thanks!

   
Reply to Guest

4

 Chris Spicer, on Sep 2, 2009 12:16:07 pm BST
  • +1

You might like to try using EasyDeeby, as it's designed for collating data like this: www.Technicana.com (Disclaimer: I am the designer of this product!).

Chris Spicer

   
Reply to Chris Spicer
Ask your question Reply
They need your help