LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Importing data from multiple excel files

I have been given 19,000 seperate excel files, each has the data laid out it
the same way, but i need to get only a few selected pieces of data from all
of them into one file,

i though about a macro, but it only seems to work for the file i created it
in, and i had some issues with information being repeatedly pasted once the
data had been moved,
anyone got any suggestions?
 
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
Importing multiple files Tommy Excel Discussion (Misc queries) 1 February 19th 07 03:00 PM
Importing multiple files Joel Excel Discussion (Misc queries) 0 February 19th 07 11:46 AM
importing multiple .dat files! via135 Excel Worksheet Functions 0 March 29th 06 08:09 PM
Importing from multiple Excel files Tired of wasting time Excel Discussion (Misc queries) 2 September 21st 05 08:22 PM
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM


All times are GMT +1. The time now is 10:47 PM.

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

About Us

"It's about Microsoft Excel"