Bubey,
There are not too many bits about linking worksheets or workbooks that I can
find.
But have a look at the links below, in case they give you the information
you need.
I think it is frustratingly one of those things which is very easy when you
know how, or if you can get someone to actually show you, but if you have
not done it before difficult to know how to start. I remember being totally
baffled when I started, but now link worksheets and books without a thought.
I don't think any of these show how to use formulae to reference another
worksheet or book. One function I use a lot between different worksheets is
vlookup, where you can look up a reference in another work book and bring
back the contents of any cell in the same row.
If you get stuck post the details of exactly what you are trying to do and
someone will most likely help (the more detail you give the more likely you
are to get a reply)
You may like to use the groups
microsoft.public.excel.newusers
or
microsoft.public.excel.misc
as I think they are more frequented.
Best of luck, Barbara
http://spider.georgetowncollege.edu/t3/wsr/csc120/sslink97.htm
http://thehub.clayton.edu/files/protect-exel.pdf
http://www.fgcu.edu/support/office2000/excel/ (a little bit in the formulas
& functions section)
http://www.du.edu/uts/training/archive/excel97/xllink97.htm (look under L
for linking)
