Dear Kishan Reddy This is a very good tip and many thanks for sharing the same. I knew about excel clip board for many years but this idea of using "Paste all" to combine all sheets is really a magic.
Thanks Chandru On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K < kishanreddy.kethire...@gmail.com> wrote: > Hello, > > Open the Office clipboard: From Menu select Edit -> Office clipboard. > > Office clipboard will appear on the right side. > > Goto sheet 1 and select Data, and Press Control+C, Data will appear on > Office Clipboard. > > Repeat the above step for all sheets. > > Then use the Paste All Option on Office clipboard. > > Then use clear all to clear all copies. > > This is the easiest and simple method. > > > > > On Jul 21, 8:40 pm, preeti vora <preeti86v...@gmail.com> wrote: > > Hi team > > > > i have one excel file there is 10 to 15 sheet different but i want to > marge > > in one sheet is that possible to do??? > > > > -- > > Regards, > > > > Preeti Vora. > > > > data.xls > > 24KViewDownload > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
