Weiers Coetser wrote:
Hi
Please send me in the right direction if my question is off topic. I am
new to spread-sheets in general and need some advice:
I am in the process of setting up a rather sizeable spreadsheet (that
should probably become a fully fledged database) to manage the
information I have for students who live in my dormitory. (I am the
dormitory dean).
The First Sheet contains all the names of the students, contact details,
parents information, medical insurance information, postal addresses
etc. It has over 40 columns.
The second Sheet contains the names of these students and their room
placements.
The third sheet contains the anmes of the students and some citizenship
records.
At the moment I am just copying the Names and Surnames from Sheet one
and Pasting them into sheet 2 and 3.
The problem is that if a new student comes I have to update all three
sheets by hand. If one name is spelled incorrectly, I have to physically
go and spell all three differently.
Is there a way that I can link the three sheets so that when I add a new
student or when I update information for a student, all the relevant
columns in the other sheets are updated?
Look at this:
<http://oooauthors.org/en/authors/userguide2/calc/calc_multiplesheets_v2_13_June_PK.sxw>.
That link may not exist in a few days, so you can download that file. It
is written for v2, but should meet you needs.
HTH,
--
Peter Kupfer -- Using OOo since 'OO4 -- [EMAIL PROTECTED]
Want to help? http://www.oooauthors.org
For OOo tips: http://openoffice.peschtra.com/ooo_tips_tricks.html
To order OOo: http://openoffice.peschtra.com/distro/ooo_distro.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
