ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i put a number of excel files into one big one? (https://www.excelbanter.com/new-users-excel/144114-how-do-i-put-number-excel-files-into-one-big-one.html)

Ianwal

how do i put a number of excel files into one big one?
 
i have a number of one line excel sheets that i want to put into one big one.
Is there a better way than cutting and pasting

Peo Sjoblom

how do i put a number of excel files into one big one?
 
You need to use macros unless this is a one timer and the number of files
are not that many

http://www.rondebruin.nl/tips.htm

look under the Copy/Paste?Merge header



--
Regards,

Peo Sjoblom




"Ianwal" wrote in message
...
i have a number of one line excel sheets that i want to put into one big
one.
Is there a better way than cutting and pasting





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

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