linking cells between worksheets

T

Tina

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.
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formulae in excel worksheets 4
Linking worksheets, rearranging rows. 1
Linking worksheets in the same workbook by names not cells 1
Linked cells between worksheets and sorting 2
Linking between worksheets 5
Code to format cells on several worksheets 2
linking dates on multiple worksheets 2
How do I lookup data from multiple worksheets? 2

Top