ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem encountered when cutting and pasting (https://www.excelbanter.com/excel-discussion-misc-queries/35773-problem-encountered-when-cutting-pasting.html)

limws1

Problem encountered when cutting and pasting
 
When I try to copy data from the first excel file to another worksheet in the
second excel file, the copied data appear in more than one worksheets in the
second file. As a result data in other worksheets in the second file got
overwritten with the copied data.

Anyone know why is this so? I'm using Excel 2000.

Ron de Bruin

Hi

You have your sheets grouped I think in the workbook where you paste.
Right click on one of the sheet tabs and click on Ungroup sheets

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


"limws1" wrote in message ...
When I try to copy data from the first excel file to another worksheet in the
second excel file, the copied data appear in more than one worksheets in the
second file. As a result data in other worksheets in the second file got
overwritten with the copied data.

Anyone know why is this so? I'm using Excel 2000.




limws1

No, I pretty sure the worksheets are not grouped together.

"Ron de Bruin" wrote:

Hi

You have your sheets grouped I think in the workbook where you paste.
Right click on one of the sheet tabs and click on Ungroup sheets

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


"limws1" wrote in message ...
When I try to copy data from the first excel file to another worksheet in the
second excel file, the copied data appear in more than one worksheets in the
second file. As a result data in other worksheets in the second file got
overwritten with the copied data.

Anyone know why is this so? I'm using Excel 2000.






All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com