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?
I thank you for giving me some advice. (Probably I should learn how to
work MySQL and programme PHP to create queries... but I am not a
developer and it will take months to learn to do that.)
Thanks
Weiers
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
