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
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

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,456
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:
 

Forum statistics

Threads
1,147,452
Messages
5,741,206
Members
423,648
Latest member
steel1968

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top