Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cameronfunk
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet


Does anyone know how to merge several (80-90) files (all set up the same
way) into 1 file? It is for an upload into an accounting program. Right
now am going the hard way by cutting and pasting for each of the 80-90
files (customer files) one at a time. Even if you could recommend a
specialty program as this is a company problem and finding a solution
would be much more efficient. Thanks to anyone who can help.


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369

  #2   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet

You may check this tip by Ron de Bruin:
http://www.rondebruin.nl/copy3.htm

Hope this helps,
Miguel.

"cameronfunk" wrote:


Does anyone know how to merge several (80-90) files (all set up the same
way) into 1 file? It is for an upload into an accounting program. Right
now am going the hard way by cutting and pasting for each of the 80-90
files (customer files) one at a time. Even if you could recommend a
specialty program as this is a company problem and finding a solution
would be much more efficient. Thanks to anyone who can help.


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369


  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet

Hi

See
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cameronfunk" wrote in message
...

Does anyone know how to merge several (80-90) files (all set up the same
way) into 1 file? It is for an upload into an accounting program. Right
now am going the hard way by cutting and pasting for each of the 80-90
files (customer files) one at a time. Even if you could recommend a
specialty program as this is a company problem and finding a solution
would be much more efficient. Thanks to anyone who can help.


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369



  #4   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet

I do like your page!

Miguel.

"Ron de Bruin" wrote:

Hi

See
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cameronfunk" wrote in message
...

Does anyone know how to merge several (80-90) files (all set up the same
way) into 1 file? It is for an upload into an accounting program. Right
now am going the hard way by cutting and pasting for each of the 80-90
files (customer files) one at a time. Even if you could recommend a
specialty program as this is a company problem and finding a solution
would be much more efficient. Thanks to anyone who can help.


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369




  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet

Thanks Miguel

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Miguel Zapico" wrote in message ...
I do like your page!

Miguel.

"Ron de Bruin" wrote:

Hi

See
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"cameronfunk" wrote in message
...

Does anyone know how to merge several (80-90) files (all set up the same
way) into 1 file? It is for an upload into an accounting program. Right
now am going the hard way by cutting and pasting for each of the 80-90
files (customer files) one at a time. Even if you could recommend a
specialty program as this is a company problem and finding a solution
would be much more efficient. Thanks to anyone who can help.


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369








  #6   Report Post  
Posted to microsoft.public.excel.misc
cameronfunk
 
Posts: n/a
Default Merge several spreadsheets into one big spreadsheet


THANK YOU THANK YOU THANK YOU. It worked beautifully. Thanks again.:) ;)


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=543369

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
Spreadsheet shortcuts not working brt Setting up and Configuration of Excel 2 April 26th 06 01:57 PM
Difficult for me, probably basic to you onlyjohn Excel Worksheet Functions 1 February 3rd 06 05:14 PM
Spreadsheets are cut off when you paste and link? Clint Lovell Excel Worksheet Functions 1 November 25th 05 06:10 PM
Mirror spreadsheet? Rykar2 Excel Discussion (Misc queries) 4 November 12th 05 03:50 AM
Spreadsheet won't let me merge cells. plse help. carikermoon Excel Discussion (Misc queries) 5 November 8th 05 11:11 PM


All times are GMT +1. The time now is 03:06 PM.

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"