Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
caduser
 
Posts: n/a
Default Insertion of existing worksheets in current worksheet

I am running Office 2003 on Win 2000. I have several worksheets that I would
like to insert into an open worksheet. Is it possible to do this without
opening each of those, and then copying and pasting?

TIA


  #2   Report Post  
Ray A
 
Posts: n/a
Default Insertion of existing worksheets in current worksheet

AFAIK you must open the files. Better than copy/paste try right click on the
sheet name and select move or copy. Use the drop down to select the workbook
you want. You have a choice of creating a copy leaving the original intact.
HTH

"caduser" wrote:

I am running Office 2003 on Win 2000. I have several worksheets that I would
like to insert into an open worksheet. Is it possible to do this without
opening each of those, and then copying and pasting?

TIA


  #3   Report Post  
caduser
 
Posts: n/a
Default Insertion of existing worksheets in current worksheet

Ray,

Small world, that is also my first name.

Your response helped a great deal. It is a pain needing to open each of the
sheets I wish to insert, but this is better than copy/pasting.

Much grass,
Ray

"Ray A" wrote:

AFAIK you must open the files. Better than copy/paste try right click on the
sheet name and select move or copy. Use the drop down to select the workbook
you want. You have a choice of creating a copy leaving the original intact.
HTH

"caduser" wrote:

I am running Office 2003 on Win 2000. I have several worksheets that I would
like to insert into an open worksheet. Is it possible to do this without
opening each of those, and then copying and pasting?

TIA


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
select lines from multiple worksheets and write to new worksheet rem Excel Worksheet Functions 1 September 15th 05 03:35 PM
Merge Worksheets Mark Jackson Excel Discussion (Misc queries) 1 June 9th 05 10:39 AM
Merge Worksheets Mark Jackson Excel Worksheet Functions 0 June 8th 05 10:42 PM
Spawning worksheets and a summary per worksheet username Excel Discussion (Misc queries) 0 May 23rd 05 09:57 PM
how do i link a number of worksheets to one master worksheet? Rusty Excel Worksheet Functions 0 January 24th 05 08:49 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"