Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default linking cells between worksheets

I have built a budget workbook with a total of 4 worksheets in it. I want to
be able to update the info on the first three and have it affect the totals
on the fourth. How can I link the information from a cell on worksheet one,
for example, to a cell on worksheet 4?

Does this make sense? I have spent an hour trying different things and can't
seem to figure it out.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 364
Default linking cells between worksheets

If you simply want to have the value in one cell of one sheet to another cell
of another sheet -
Go where you want the value to be
Enter =
Click on the other sheet and then the cell which has the value
Press Enter and you are done

"Tina" wrote:

I have built a budget workbook with a total of 4 worksheets in it. I want to
be able to update the info on the first three and have it affect the totals
on the fourth. How can I link the information from a cell on worksheet one,
for example, to a cell on worksheet 4?

Does this make sense? I have spent an hour trying different things and can't
seem to figure it out.


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
Linking cells in different worksheets Kathy at Sauder Feeds Excel Worksheet Functions 1 September 17th 07 03:13 PM
Linking Cells from different worksheets JasonG Excel Discussion (Misc queries) 6 June 12th 07 01:08 PM
Linking Cells on different worksheets tcreller Excel Discussion (Misc queries) 5 April 22nd 07 02:25 AM
linking cells between worksheets Dawn101 Excel Discussion (Misc queries) 3 January 22nd 07 03:28 PM
formulas for linking cells in different worksheets desperate measures Excel Worksheet Functions 5 August 23rd 06 11:31 PM


All times are GMT +1. The time now is 07:22 PM.

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

About Us

"It's about Microsoft Excel"