Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Extruder Johnny
 
Posts: n/a
Default How do I combine several sheets into one document in Excel?


  #2   Report Post  
Bryan Hessey
 
Posts: n/a
Default


As you did not specify otherwise I presume there is something like Sheet
1 has rows 1 to 250, sheet 2 has rows 1 to 500, and sheet 3 has rows 1
to 250 etc.

To join those you would highlight and Copy the rows in sheet 2, then,
then in sheet 1 click in cell A251 and Paste, then repeat the process
for sheet three into cell A751 etc.

If you wish to match-and-merge data on the same rows from columns in
another sheet that could be more difficult.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390749

  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi

With code you can do this
http://www.rondebruin.nl/copy2.htm

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


"Extruder Johnny" <Extruder wrote in message
...



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
Combine to Sheets... JFALK Excel Discussion (Misc queries) 2 June 29th 05 03:58 PM
Header or Footer to show up on multiple sheets in a document Holly Domine Excel Worksheet Functions 1 May 23rd 05 07:17 PM
HELP!!! combine 4 different sheets ??? TonyKA Excel Discussion (Misc queries) 0 May 13th 05 04:05 PM
Can I combine 100+ sheets from different workbooks into one worksh bootstrapgroup Excel Discussion (Misc queries) 0 April 8th 05 10:17 PM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 08:37 PM


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