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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|