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
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 cl
Hi Preeti
Please find attached the solution as required, do let me know if something
else is required.
Regards,
Rajender Soni | +91 750 322 55 50
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi preeti,
This code covers your task, you can run it and enjoy. It was
interesting problem to solve. Please tell us does it work for you.
Sub automate()
Dim i, j, k, n, myfile, mySheet
Call ListWorkSheetNames
myfile = ActiveWorkbook.FullName
Sheets("main sheet").Select
Cells.Select
Hi preeti,
This code covers your task, you can run it and enjoy. It was
interesting problem to solve. Please tell us does it work for you.
Sub automate()
Dim i, j, k, n, myfile, mySheet
Call ListWorkSheetNames
myfile = ActiveWorkbook.FullName
Sheets("main sheet").Select
Cells.Select
