Help with a school Directory

[Closed]
Report
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
Hi all,

I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade.

I have a master list on one sheet with all the students names, only a few now, and I will be adding and subtracting names each year and throughout this year.

What I would like to do is have the entire row of a students name with the rest of the rows information be sent to a corresponding teacher sheet when that teachers name is entered in the column. This will allow the class lists to all be updated from the master list on its own sheet.

Is this possible?

Thanks

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,912
I suggest you use database software (like Access) rather than spreadsheet software (like Excel).

Perhaps you should read this:

https://www.microsoft.com/en-us/microsoft-365/access