Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Creating links in work book
I would like to Link cells to worksheet so that when entering data in one
cell the other cells will have the same data inputted automatically. For instance, I have three worksheets, ws1, ws2, and ws3. In each of the worksheets there are several cells that contain the same data. I would like to link the cells so that if I go in anyone of the worksheets to update the data, the other worksheets get updated atomatically. |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Creating links in work book
You would use a Change Event macro in each of the 3 worksheets,
to do that if they are constants in the same position. http://www.mvps.org/dmcritchie/excel/event.htm Another way would be to group the sheets. Do remember to ungroup the sheets afterwards as any change made to one in the group would be made to all in the group so while useful for entering same data into several sheets it can also destroy your workbook if you forget to ungroup sheets. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "boccuz" wrote in message ... I would like to Link cells to worksheet so that when entering data in one cell the other cells will have the same data inputted automatically. For instance, I have three worksheets, ws1, ws2, and ws3. In each of the worksheets there are several cells that contain the same data. I would like to link the cells so that if I go in anyone of the worksheets to update the data, the other worksheets get updated atomatically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I put a Print command in a work book | Excel Discussion (Misc queries) | |||
Creating a new chart- why Set NewChart = Charts.Add doesn't work? | Charts and Charting in Excel | |||
Creating links to a worksheet on a network. | Excel Worksheet Functions | |||
Links to other sheets only work if the sheet is opened | Excel Discussion (Misc queries) | |||
Updating Automatic links doesn't work with arrays | Excel Discussion (Misc queries) |