ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy/Move Worksheet from one Workbook to another (https://www.excelbanter.com/excel-discussion-misc-queries/122630-copy-move-worksheet-one-workbook-another.html)

Anney

Copy/Move Worksheet from one Workbook to another
 


Guys,

I have different 8 workbooks each having one worksheet inside it. I want to
copy these all workbooks in another workbook as a summary of whole project.

Unfortunately when i right click on sheet tab, all options are siable and i
can't Copy/Move these worksheets. (Some of formulas are interlinked with
oneanother worksheets).

I tried my best but unable to locate problem.

Kindly help me out. Its urgent

Regards

Qurrat
Engineering Associates
Karachi, Pakistan

Dave Peterson

Copy/Move Worksheet from one Workbook to another
 
I'd look to see if the workbook is protected:

Tools|protection|Unprotect workbook
(you may need to supply a password to unprotect it)

Anney wrote:

Guys,

I have different 8 workbooks each having one worksheet inside it. I want to
copy these all workbooks in another workbook as a summary of whole project.

Unfortunately when i right click on sheet tab, all options are siable and i
can't Copy/Move these worksheets. (Some of formulas are interlinked with
oneanother worksheets).

I tried my best but unable to locate problem.

Kindly help me out. Its urgent

Regards

Qurrat
Engineering Associates
Karachi, Pakistan


--

Dave Peterson

Anney

Copy/Move Worksheet from one Workbook to another
 
Dear Dave,

I tried to unprotect sheet, but its asking for a password.

I am unable to define password, tell me how can i unprotect it.

I also tried to run passwordbreaker macro, but still unable.

Guide me what i do??

Regards,

Qurrat

"Dave Peterson" wrote:

I'd look to see if the workbook is protected:

Tools|protection|Unprotect workbook
(you may need to supply a password to unprotect it)

Anney wrote:

Guys,

I have different 8 workbooks each having one worksheet inside it. I want to
copy these all workbooks in another workbook as a summary of whole project.

Unfortunately when i right click on sheet tab, all options are siable and i
can't Copy/Move these worksheets. (Some of formulas are interlinked with
oneanother worksheets).

I tried my best but unable to locate problem.

Kindly help me out. Its urgent

Regards

Qurrat
Engineering Associates
Karachi, Pakistan


--

Dave Peterson


Dave Peterson

Copy/Move Worksheet from one Workbook to another
 
Talk to the originator and ask him or her for the password. If he/she doesn't
want to give it to you, maybe there's a good reason.

Anney wrote:

Dear Dave,

I tried to unprotect sheet, but its asking for a password.

I am unable to define password, tell me how can i unprotect it.

I also tried to run passwordbreaker macro, but still unable.

Guide me what i do??

Regards,

Qurrat

"Dave Peterson" wrote:

I'd look to see if the workbook is protected:

Tools|protection|Unprotect workbook
(you may need to supply a password to unprotect it)

Anney wrote:

Guys,

I have different 8 workbooks each having one worksheet inside it. I want to
copy these all workbooks in another workbook as a summary of whole project.

Unfortunately when i right click on sheet tab, all options are siable and i
can't Copy/Move these worksheets. (Some of formulas are interlinked with
oneanother worksheets).

I tried my best but unable to locate problem.

Kindly help me out. Its urgent

Regards

Qurrat
Engineering Associates
Karachi, Pakistan


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 10:58 PM.

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