Help please. Please help with this thread, excel sheet movement!!! Thanks.

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
I have an excel sheet(Sheet1) in Workbook name book1
I want to move this sheet to different workbook name book2
In Sheet1 I have all the different formulas in differents cells in random order. So please help me in moving sheet1 from book1 to Book2. I want all the formulas, validation, conditional formatting etc to be where it is.

Is there a possible way??? with macro or without macro....anyway?:p



Thanks Ped:p
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Is it?

Code:
Workbooks("Book1.xls").Sheet1.Copy Destination:=Workbooks("book2.xls")
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Where do i input this code...in Book1 or Book2, and how exactly do i input, so I insert this as module and run it.:biggrin:
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
It is giving
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p> </o:p>
Run-time error ‘438’<o:p></o:p>
Object doesn’t support this property or method.<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p>Not sure how to make it work.</o:p>
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875

ADVERTISEMENT

:rolleyes::eek:
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Hi Pedie,
Without any vba you can try this.
Open Book1 and Book2.
Go to Book1 and right click the sheet tab & choose 'Move or Copy...'.
If you want to move the sheet (removing it from Book1) then do not check the 'Create a copy' checkbox. If you want to copy the sheet to Book2, then check the checkbox.
Next in the dropdown labeled 'Move selected sheets to:' choose Book2.
In the listbox below you can choose where in Book2 you want the sheet to be.

Does that help?
 

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Hi Dan....!!! Thanks alot!

I was reading the same information from MSoffice supprot but didnt quite understand it..lol!!!

Thanks, now i can carry it from here.

Pedie!:cool:
 

Watch MrExcel Video

Forum statistics

Threads
1,108,448
Messages
5,523,051
Members
409,494
Latest member
Itsmeerc

This Week's Hot Topics

Top