Help with a school Directory

Closed
directoryhelp - Aug 24, 2015 at 06:56 PM
xpcman Posts 19528 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
Related:

1 response

xpcman Posts 19528 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,824
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