Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum all sheets if Column L | Excel Discussion (Misc queries) | |||
All sheets opening at column IV - help! | Excel Discussion (Misc queries) | |||
Repeat column in all sheets | Excel Discussion (Misc queries) | |||
One cell from several sheets to one column | Excel Discussion (Misc queries) | |||
How can give the same name to a row or column in different sheets. | Excel Discussion (Misc queries) |