Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default appending worksheet records into 1 worksheet

I've numerous spreadsheets (~680) with multiple worksheets, (worksheets
identically formatted and named)

I wish to merge/append the records of coinciding worksheets into a master
prior to export to Access. What is best way to automate a such a process?
no records will be combined just appended to one another.
--
Jim
Reply
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
Copying records from a date interval from one worksheet to another ricky[_2_] Excel Discussion (Misc queries) 1 July 22nd 07 05:32 AM
filtering out records from one worksheet by comparing a field in it with a field in another worksheet [email protected] New Users to Excel 0 May 9th 07 01:06 AM
remove blank records (row) in worksheet sahusir Excel Discussion (Misc queries) 2 October 14th 06 05:12 PM
how to group records in a new worksheet Gunther Excel Worksheet Functions 1 March 1st 06 10:37 AM
how to group records in a new worksheet Gunther Excel Discussion (Misc queries) 1 February 22nd 06 06:59 AM


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