Question about Excell

Joel · 12th October 2010, 16:57

Hi all...

I have excell file...which have 5 sheets (tabs)...

Is it possible to copy the contents of the sheet1 to the others including margins, border styles, colors, etc..?

Warrior of the Light · 12th October 2010, 18:45

Try copying what you need and then the "paste special" function from the Edit menu (or through right-clicking)

Scar Da Kookee · 13th October 2010, 05:04

yeah, thats about it. ^

samortan · 13th October 2010, 15:36

Yes everything is possible. You just need to work harder. And find some more techniques.

Warrior of the Light · 13th October 2010, 16:01

?

Joel · 14th October 2010, 02:44

@Warrior of the Light: Thanks, yes copy-paste should be the instant solution, but my idea is if I made a change in sheet #1, all the sheets update too.

LAKEL.AMBERT · 14th October 2010, 08:05

Where to download the "Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 and later File Formats" (Compatibility Pack) package that enables you to open, edit, and save documents, workbooks, and presentations in the file formats that are new in the 2007 version and later versions of Microsoft Office programs.

Warrior of the Light · 14th October 2010, 14:13

I couldn't find anything for it..
Linking the content is easy: as a formula it's something like =Sheet1!A1 but when it comes to layout, I can't find a thing.
Perhaps you could try asking on an Office forum aswell?

QOAL · 14th October 2010, 14:55

You'd need to make a macro (well VBA script) to do it.

Apparently something like this:

code:
    Range("A1:E11").Copy

    Sheets("Sheet2").Range("A1:E11").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _

        False, Transpose:=False

    Application.CutCopyMode = False

Tie it to a button or a function of the sheet/workbook.

But yeah, is that what you want?

thinktink · 14th October 2010, 15:12

Isn't there an OnUpdate or something similar event for the Excel VBA object you can chuck that script into? Been a while since I done did anything that involved in Excel.

QOAL · 14th October 2010, 15:24

Yeah there is an on change sub you can have for each sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
That's actually what I tested it with, but if you're making many changes then having it update less often would be nicer.

(For reference, to add this function etc: Tools -> Macro -> Visual Basic Editor -> Double click sheet one on list, copy paste away and edit to taste)
Tested on Office 2002

Widdykats · 16th October 2010, 09:32

^ That's why he's "Super Hero"

swingdjted · 17th October 2010, 22:21

*plays cheesy cartoon hero music*

12th October 2010, 18:45	#2
Warrior of the Light Forum King Join Date: Aug 2002 Location: The Netherlands Posts: 4,121	Try copying what you need and then the "paste special" function from the Edit menu (or through right-clicking) Jesus loves you [yes, you] so much, he even died for you so that you will not need to die, but live forever

13th October 2010, 05:04	#3
Scar Da Kookee [Forum Pastry] Join Date: Jun 2001 Posts: 1,032	yeah, thats about it. ^ Needs more moo-cows.

13th October 2010, 16:01	#5
Warrior of the Light Forum King Join Date: Aug 2002 Location: The Netherlands Posts: 4,121	? Jesus loves you [yes, you] so much, he even died for you so that you will not need to die, but live forever

14th October 2010, 02:44	#6
Joel Debian user (Forum King) Join Date: Jan 2003 Location: Arch land Posts: 4,917	@Warrior of the Light: Thanks, yes copy-paste should be the instant solution, but my idea is if I made a change in sheet #1, all the sheets update too. * PC: Intel Core 2 DUO E6550 @ 2.33 GHz with 2 GB RAM: Archlinux-i686 with MATE. * Laptop: Intel Core 2 DUO T6600 @ 2.20 GHz with 4 GB RAM: Archlinux-x86-64 with MATE.

14th October 2010, 14:13	#8
Warrior of the Light Forum King Join Date: Aug 2002 Location: The Netherlands Posts: 4,121	I couldn't find anything for it.. Linking the content is easy: as a formula it's something like =Sheet1!A1 but when it comes to layout, I can't find a thing. Perhaps you could try asking on an Office forum aswell? Jesus loves you [yes, you] so much, he even died for you so that you will not need to die, but live forever

12th October 2010, 16:57	#1
Joel Debian user (Forum King) Join Date: Jan 2003 Location: Arch land Posts: 4,917	Question about Excell Hi all... I have excell file...which have 5 sheets (tabs)... Is it possible to copy the contents of the sheet1 to the others including margins, border styles, colors, etc..? * PC: Intel Core 2 DUO E6550 @ 2.33 GHz with 2 GB RAM: Archlinux-i686 with MATE. * Laptop: Intel Core 2 DUO T6600 @ 2.20 GHz with 4 GB RAM: Archlinux-x86-64 with MATE.

13th October 2010, 15:36	#4
samortan Junior Member Join Date: Oct 2010 Posts: 8	Yes everything is possible. You just need to work harder. And find some more techniques.

14th October 2010, 08:05	#7
LAKEL.AMBERT Banned Join Date: Oct 2010 Posts: 5	Where to download the "Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 and later File Formats" (Compatibility Pack) package that enables you to open, edit, and save documents, workbooks, and presentations in the file formats that are new in the 2007 version and later versions of Microsoft Office programs.

14th October 2010, 14:55	#9
QOAL [STILL a retard!] Join Date: Apr 2002 Location: Bristol, UK Posts: 1,167	You'd need to make a macro (well VBA script) to do it. Apparently something like this: code: Range("A1:E11").Copy Sheets("Sheet2").Range("A1:E11").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False Tie it to a button or a function of the sheet/workbook. But yeah, is that what you want? count! • last.fm • planner

14th October 2010, 15:12	#10
thinktink Forum King Join Date: May 2009 Location: No longer on the streets of Kings County, CA. Posts: 3,087	Isn't there an OnUpdate or something similar event for the Excel VBA object you can chuck that script into? Been a while since I done did anything that involved in Excel.

14th October 2010, 15:24	#11
QOAL [STILL a retard!] Join Date: Apr 2002 Location: Bristol, UK Posts: 1,167	Yeah there is an on change sub you can have for each sheet: Private Sub Worksheet_Change(ByVal Target As Range) End Sub That's actually what I tested it with, but if you're making many changes then having it update less often would be nicer. (For reference, to add this function etc: Tools -> Macro -> Visual Basic Editor -> Double click sheet one on list, copy paste away and edit to taste) Tested on Office 2002 count! • last.fm • planner

16th October 2010, 09:32	#12
Widdykats The Forum Slut Join Date: Jun 2002 Location: A place that invites a post pumping whore from NY Posts: 15,787	^ That's why he's "Super Hero" Last edited by Widdykats; 2nd December 2013 at 15:45.

17th October 2010, 22:21	#13
swingdjted DRINK BEER NOW (Forum King) Join Date: Feb 2006 Location: Northern West Virginia Posts: 10,064	plays cheesy cartoon hero music Don't forget to live before you die.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode