how can i relate between two columns in two sheets?

B

Bernard Liengme

Question no too clear - you can use this space to give a detailed question.
But here goes:
On Sheet1 I can type formulas such as
=Sheet2!A1
=SUM(Sheet2!A:A10)

If I type = and then click on the cell A1 of a worksheet called My Yearly
Totals, I will get the formula
='My Yearly Totals'!A1
Note that a sheet name having spaces get surrounded by single quotes.
Does this answer your question?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/office/default.aspx#tab=4
 

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

How to sort data in excel 2000? 3
Cheque Print 0
How do I get two dots on the e in Zoe 3
How can I isolate the last two words in a text string? 7
How can I compare data between two different sheets for changes? 0
how do i run a search between two spreadsheets 0
Tough question: How do I make a dot between two words for a graphiceffect in a page heading? 5
How do I list all Data in a column that fits between two points? 2

Top