ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merge several spreadsheets into one big spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/89341-merge-several-spreadsheets-into-one-big-spreadsheet.html)

cameronfunk

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


Miguel Zapico

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



Ron de Bruin

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




Miguel Zapico

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





Ron de Bruin

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







cameronfunk

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



All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com