Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 20th 07, 06:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 1
Default How do I create a connection between cells on different worksheets

I am trying to create a connection or reference between cells on different
worksheets within the same workbook that will automatically propogate as data
is changed within the ference cell. I am using Excel 2003. Hope this makes
sense and someone can help. Thanks!

  #2   Report Post  
Old December 20th 07, 06:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 50
Default How do I create a connection between cells on different worksheets

brada_awan,
You should be able to have this happen by having the first cell equal the
second cell.
Something like this:
Select the cell in the first sheet that you want to reference by clicking in
it.
Hit the = sign and then go to the other cell that you want to have show in
the first cell.
If you are on Sheet 1, Cell B4 and wanted it to show Sheet 2, Cell B4, it
should look something like this: =Sheet2!B4
Anytime you changed the data in Sheet 2, cell B4 the cell in Sheet 1 would
change and show that data.


"brada_awan" wrote:

I am trying to create a connection or reference between cells on different
worksheets within the same workbook that will automatically propogate as data
is changed within the ference cell. I am using Excel 2003. Hope this makes
sense and someone can help. Thanks!

  #3   Report Post  
Old December 20th 07, 06:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 1
Default How do I create a connection between cells on different worksh

Thanks so much Fleone!

"Fleone" wrote:

brada_awan,
You should be able to have this happen by having the first cell equal the
second cell.
Something like this:
Select the cell in the first sheet that you want to reference by clicking in
it.
Hit the = sign and then go to the other cell that you want to have show in
the first cell.
If you are on Sheet 1, Cell B4 and wanted it to show Sheet 2, Cell B4, it
should look something like this: =Sheet2!B4
Anytime you changed the data in Sheet 2, cell B4 the cell in Sheet 1 would
change and show that data.


"brada_awan" wrote:

I am trying to create a connection or reference between cells on different
worksheets within the same workbook that will automatically propogate as data
is changed within the ference cell. I am using Excel 2003. Hope this makes
sense and someone can help. Thanks!



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
always recheck data connection library for latest connection strin FurmanGG Excel Discussion (Misc queries) 0 September 14th 07 04:48 PM
How use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
Copying Cells From Multiple Worksheets to Create Summary Sheet lee Excel Discussion (Misc queries) 1 October 6th 06 05:13 PM
How do I create a formula using cells from multiple worksheets? genevie Excel Worksheet Functions 1 July 14th 06 10:11 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 07:15 PM


All times are GMT +1. The time now is 09:53 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017