ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying spreadsheets-did not work (https://www.excelbanter.com/excel-discussion-misc-queries/58842-copying-spreadsheets-did-not-work.html)

tazsdad

Copying spreadsheets-did not work
 
Still don't have a clear answer. The problem is this... I,m trying to save
only a portion of a spreadsheet I have created to another folder. Each time I
copy and paste, it copies the entire spreadsheet and not just what I have
highlited.
Dave, using |goto|special|visible cells only....had no effect. please advise

Dave Peterson

Copying spreadsheets-did not work
 
It's better to stay in the same thread.

Do you have both workbooks open in the same excel instance.

Close excel (as many as you have open).

Then open excel
Then file|open your first workbook
then file|open the second workbook

Then try the copy|paste.



tazsdad wrote:

Still don't have a clear answer. The problem is this... I,m trying to save
only a portion of a spreadsheet I have created to another folder. Each time I
copy and paste, it copies the entire spreadsheet and not just what I have
highlited.
Dave, using |goto|special|visible cells only....had no effect. please advise


--

Dave Peterson


All times are GMT +1. The time now is 12:02 PM.

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