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: 1
Default Need to merge 1500 files into 1!!!

I currently have 1500 different Excel files from a survey. The top ro
contains the question and the 2nd row contains the answers. What
would like to do if find a way to take the information in the 2nd ro
of each file and dump it into one spreadsheet.

I can write a macro to copy paste the information, however, the file
that I am copying the information from are obviously named differentl
and I am not sure how to tell Excel to paste in the next available ro
only a particular cell.

Is there a way that I could automate this entire process instead o
opening up each file and copy paste?

Any help in the right direction is greatly appreciated!
Thanks in advance

--
Message posted from http://www.ExcelForum.com

 
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
merge two excel files like in word mail merge azmerritt Excel Discussion (Misc queries) 1 December 11th 16 09:23 PM
Time format 1500 become 15:00 tran1728 Excel Discussion (Misc queries) 4 May 7th 10 12:33 AM
merge 2 files reza Excel Discussion (Misc queries) 3 January 26th 10 05:53 PM
I wana prepare a pay roll of employee of 1500 [email protected] Excel Discussion (Misc queries) 2 July 21st 07 01:20 PM
'Average' Function on 1500 lines Logan New Users to Excel 2 May 25th 05 11:40 PM


All times are GMT +1. The time now is 11:32 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"