| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make columns in one sheet match columns from another sheet
I have four columns of data that need to be exactly the same on two
worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make columns in one sheet match columns from another sheet
Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then
paste link in Sheet B) or simply type = in a cell in the sheet B and click in corresponding cell in sheet B, enter, then click and drag the cell down and across. "Zoe Hu" wrote: I have four columns of data that need to be exactly the same on two worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make columns in one sheet match columns from another sh
Vibeke
You can "Group" the two worksheets while updating the first sheet. What happens to the first will happen to the second. There are some limitations but I don't think your what is on list is among them. Save a copy and give it a try. With the first sheet active hold down "ctrl" and select the second sheet, you will see "[group]" in the blue bar at the top of the page. Now what you do to the first sheet will happen to the second. REMEMBER to "ungroup" when you are done by selecting one of the sheets and you will see "[group]" go away. You can also right click a tab and select "ungroup" to do the same thing. hth Mike Rogers "Vibeke" wrote: Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then paste link in Sheet B) or simply type = in a cell in the sheet B and click in corresponding cell in sheet B, enter, then click and drag the cell down and across. "Zoe Hu" wrote: I have four columns of data that need to be exactly the same on two worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make columns in one sheet match columns from another sh
That'll teach me to not read a question carefully! You're quite right, thanks!
"Mike Rogers" wrote: Vibeke You can "Group" the two worksheets while updating the first sheet. What happens to the first will happen to the second. There are some limitations but I don't think your what is on list is among them. Save a copy and give it a try. With the first sheet active hold down "ctrl" and select the second sheet, you will see "[group]" in the blue bar at the top of the page. Now what you do to the first sheet will happen to the second. REMEMBER to "ungroup" when you are done by selecting one of the sheets and you will see "[group]" go away. You can also right click a tab and select "ungroup" to do the same thing. hth Mike Rogers "Vibeke" wrote: Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then paste link in Sheet B) or simply type = in a cell in the sheet B and click in corresponding cell in sheet B, enter, then click and drag the cell down and across. "Zoe Hu" wrote: I have four columns of data that need to be exactly the same on two worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make columns in one sheet match columns from another sh
Vibeke
I had a miss Q!!! That was supposed to go to the op...but I guess information is information... Keep up the good work!!! Mike Rogers "Vibeke" wrote: That'll teach me to not read a question carefully! You're quite right, thanks! "Mike Rogers" wrote: Vibeke You can "Group" the two worksheets while updating the first sheet. What happens to the first will happen to the second. There are some limitations but I don't think your what is on list is among them. Save a copy and give it a try. With the first sheet active hold down "ctrl" and select the second sheet, you will see "[group]" in the blue bar at the top of the page. Now what you do to the first sheet will happen to the second. REMEMBER to "ungroup" when you are done by selecting one of the sheets and you will see "[group]" go away. You can also right click a tab and select "ungroup" to do the same thing. hth Mike Rogers "Vibeke" wrote: Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then paste link in Sheet B) or simply type = in a cell in the sheet B and click in corresponding cell in sheet B, enter, then click and drag the cell down and across. "Zoe Hu" wrote: I have four columns of data that need to be exactly the same on two worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to make columns in one sheet match columns from another sh
Mike,
This is so handy. Thanks a lot for the help. Zoe "Mike Rogers" wrote: Vibeke I had a miss Q!!! That was supposed to go to the op...but I guess information is information... Keep up the good work!!! Mike Rogers "Vibeke" wrote: That'll teach me to not read a question carefully! You're quite right, thanks! "Mike Rogers" wrote: Vibeke You can "Group" the two worksheets while updating the first sheet. What happens to the first will happen to the second. There are some limitations but I don't think your what is on list is among them. Save a copy and give it a try. With the first sheet active hold down "ctrl" and select the second sheet, you will see "[group]" in the blue bar at the top of the page. Now what you do to the first sheet will happen to the second. REMEMBER to "ungroup" when you are done by selecting one of the sheets and you will see "[group]" go away. You can also right click a tab and select "ungroup" to do the same thing. hth Mike Rogers "Vibeke" wrote: Use Edit menu\Paste Special\paste link (ie copy all from sheet A then then paste link in Sheet B) or simply type = in a cell in the sheet B and click in corresponding cell in sheet B, enter, then click and drag the cell down and across. "Zoe Hu" wrote: I have four columns of data that need to be exactly the same on two worksheets. How can I make those columns on sheet B be automatically updated when I make any chage to sheet A. Those changes can be text update, row insertion/deletion, and ideally, formatting. Do I need a macro to do this? Does anyone have a similar macro for me to start with? Thanks Zoe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Insert Columns in a big Sheet... | Excel Worksheet Functions | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Take 3 columns, one per sheet and turn it into one on 4th sheet | Excel Worksheet Functions | |||
| Can I add more columns to a spread sheet or is limit 256 columns | Excel Discussion (Misc queries) | |||
| TEX TO COLUMNS PROTECTED SHEET | Excel Discussion (Misc queries) | |||
Linear Mode
