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