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 Merging data from different workbooks

A list of excel files with complete path is entered into column A of
the workbook. Is it possible to open those files and paste the visible
rows into new excel workbook. There are more than 50 files to be
opened and pasted. One thing need to be sure while pasting, that when
second file is opened and pasted, numbers are pasted at the last row
of new excel workbook created.

Thanks in advance.
 
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
Merging Data from Two Different Workbooks on a Common Key Alan Auerbach Excel Programming 10 November 23rd 09 09:27 AM
Merging data from two workbooks into one Candy Excel Discussion (Misc queries) 1 August 8th 07 09:13 PM
add vs. replace data when merging workbooks Richard Meister Excel Worksheet Functions 0 August 14th 06 03:19 PM
Merging Data from Workbooks Bryan Potter Excel Discussion (Misc queries) 2 July 13th 06 02:44 PM
Merging data from several workbooks Louise Excel Worksheet Functions 3 December 1st 04 05:53 PM


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