Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Excel 2003


  • Please log in to reply
2 replies to this topic

#1 HitSquad

HitSquad

    You're Bleepin' or you're Weepin'


  • Members
  • 1,573 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Momma
  • Local time:11:53 PM

Posted 24 April 2006 - 11:49 AM

Could someone tell me how to link (not hyperlink, I know how to do that) data entered in a specific cell on one sheet to also be entered in to a specific cell on another sheet simultaneously?

BC AdBot (Login to Remove)

 


m

#2 jgweed

jgweed

  • Staff Emeritus
  • 28,473 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Chicago, Il.
  • Local time:11:53 PM

Posted 24 April 2006 - 01:24 PM

It works similarly to linking a cell in the same worksheet.
Say A4 is the original cell; the same worksheet is linked by "=a4" in the target cell. If you want to link to a cell in another workbook, then it is "=sheet1!a4" in the target cell in the other worksheet, where sheet1 is the name of the original worksheet. Any value entered (you may want to remember to format the target if needed) in a4 would then appear in the target cell in the other worksheet.

Regards,
John

Edited by jgweed, 24 April 2006 - 01:25 PM.

Whereof one cannot speak, thereof one should be silent.

#3 HitSquad

HitSquad

    You're Bleepin' or you're Weepin'

  • Topic Starter

  • Members
  • 1,573 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Momma
  • Local time:11:53 PM

Posted 24 April 2006 - 01:30 PM

Too simple. :thumbsup:
Thanks jgweed.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users