Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
boccuz
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.links
David McRitchie
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I put a Print command in a work book HyLee Hansen Excel Discussion (Misc queries) 2 October 28th 05 07:29 PM
Creating a new chart- why Set NewChart = Charts.Add doesn't work? Thief_ Charts and Charting in Excel 7 May 1st 05 03:32 AM
Creating links to a worksheet on a network. Peter Vousden Excel Worksheet Functions 0 April 7th 05 01:17 AM
Links to other sheets only work if the sheet is opened Arnold de Lange Excel Discussion (Misc queries) 3 December 28th 04 03:12 PM
Updating Automatic links doesn't work with arrays Mats Samson Excel Discussion (Misc queries) 0 December 18th 04 03:17 PM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"