Help with a school Directory

Closed
directoryhelp - Aug 24, 2015 at 06:56 PM
xpcman
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
- Aug 24, 2015 at 07:17 PM
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

xpcman
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,829
Aug 24, 2015 at 07:17 PM
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
0