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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Is it?

Code:
Workbooks("Book1.xls").Sheet1.Copy Destination:=Workbooks("book2.xls")
 
Upvote 0
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:
 
Upvote 0
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>
 
Upvote 0
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?
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,218,909
Messages
6,145,166
Members
450,592
Latest member
Boulder127

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
Back
Top