#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Copy or Move

Dear All
I have lot of work sheets in one excel work book , i want all work sheet in
one sheet. is there any possiblities to move all sheet to one sheet without
coppy or cut and paste
thanks

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Copy or Move

You can use a macro to copy or move the data for you.
--
Gary''s Student - gsnu200909


"Fareez" wrote:

Dear All
I have lot of work sheets in one excel work book , i want all work sheet in
one sheet. is there any possiblities to move all sheet to one sheet without
coppy or cut and paste
thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default Copy or Move

Hi,
look into Ron web

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

That merge all worksheets into one master

"Fareez" wrote:

Dear All
I have lot of work sheets in one excel work book , i want all work sheet in
one sheet. is there any possiblities to move all sheet to one sheet without
coppy or cut and paste
thanks

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Copy or Move

Use this:
http://www.rondebruin.nl/copy2.htm

Let me know if you have any questions.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Fareez" wrote:

Dear All
I have lot of work sheets in one excel work book , i want all work sheet in
one sheet. is there any possiblities to move all sheet to one sheet without
coppy or cut and paste
thanks

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
move or copy jaz Excel Worksheet Functions 1 July 10th 08 06:48 PM
move or copy sheets doesn't copy format ColinX Excel Worksheet Functions 1 May 14th 08 10:07 PM
Can I Move replace instead of Move copy [email protected] Excel Discussion (Misc queries) 2 January 9th 08 10:25 PM
Move/Copy or Copy/Insert worksheet? kjk Excel Discussion (Misc queries) 0 December 15th 06 02:40 PM
Move or Copy helen Excel Discussion (Misc queries) 2 November 8th 06 08:15 PM


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