A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

One column for many sheets



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2009, 04:17 PM posted to microsoft.public.excel.links
Jeff Gordon
external usenet poster
 
Posts: 9
Default One column for many sheets

Hi!

How I can manage as follow:

I have one column in one sheet filled with text, comment box and links and
there is a lot of other sheets. I want to upgrade that one text sheet with
one column and then show that column for other ones. Can I link it somehow?
The idea was, to show everything in that one column in other sheets with
comment box and formats.

I just tried to merge all sheets and make my changes then in one of those,
but I need to copy comment box and formats also, but I don't know how to do
this. Does anyone have an idea?

Many thanks!

JG


  #2  
Old March 16th, 2009, 08:34 PM posted to microsoft.public.excel.links
Gary''s Student
external usenet poster
 
Posts: 7,584
Default One column for many sheets

Try this small macro:

Sub copycolumn()
Set r = Range("B:B")
Set sh = ActiveSheet
shn = sh.Name
For Each sht In Sheets
shtn = sht.Name
If shtn shn Then
r.Copy sht.Range("B1")
End If
Next
End Sub

--
Gary''s Student - gsnu200839


"Jeff Gordon" wrote:

Hi!

How I can manage as follow:

I have one column in one sheet filled with text, comment box and links and
there is a lot of other sheets. I want to upgrade that one text sheet with
one column and then show that column for other ones. Can I link it somehow?
The idea was, to show everything in that one column in other sheets with
comment box and formats.

I just tried to merge all sheets and make my changes then in one of those,
but I need to copy comment box and formats also, but I don't know how to do
this. Does anyone have an idea?

Many thanks!

JG



  #3  
Old March 17th, 2009, 09:40 PM posted to microsoft.public.excel.links
Jeff Gordon
external usenet poster
 
Posts: 9
Default One column for many sheets

Hello!

That make my day. Thanks!

JG

"Gary''s Student" wrote in message
...
Try this small macro:

Sub copycolumn()
Set r = Range("B:B")
Set sh = ActiveSheet
shn = sh.Name
For Each sht In Sheets
shtn = sht.Name
If shtn shn Then
r.Copy sht.Range("B1")
End If
Next
End Sub

--
Gary''s Student - gsnu200839


"Jeff Gordon" wrote:

Hi!

How I can manage as follow:

I have one column in one sheet filled with text, comment box and links
and
there is a lot of other sheets. I want to upgrade that one text sheet
with
one column and then show that column for other ones. Can I link it
somehow?
The idea was, to show everything in that one column in other sheets with
comment box and formats.

I just tried to merge all sheets and make my changes then in one of
those,
but I need to copy comment box and formats also, but I don't know how to
do
this. Does anyone have an idea?

Many thanks!

JG





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.