Referencing between worksheets

A

albiathar

I would like to make an excel workbook to calculate mortgage payment
based on the cost of a home, current interest rates, and the differen
programs my company uses. I would like to have a single page for m
ding-bat co-workers to input this info, as working in excel seems to b
too advanced for them. I would then like to reference this to othe
worksheets (which they could then use for sales calls).

So, I'd like to take Info from Sheet1 and reference it on sheet2, 3
etc. I can not find how to do this (if it is even possible). Ca
someone tell me how (if) I can do it?

Thanks
 
B

Bob Phillips

=Sheet1!A1



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top