I have a sheet in which column A is filled with names of students rest of the columns are empty. I have eight tabs on the same sheet with names of subjects: ENGLISH, MATH, PHYSICS, CHEMISTRY, BIOLOGY, BUSINESS ST., ECONOMICS, COMPUTER ST.
I wish the students to be assigned to subjects of ENGLISH, MATH, PHYSICS, CHEMISTRY, BIOLOGY, BUSINESS ST., ECONOMICS, COMPUTER ST. So when I type the name of the subject next to the name, his name should be copied to the corresponding subject sheet.
eg. if A2 has the name Mark and I enter PHYSICS in B2, CHEMISTRY in C2, BIOLOGY in D2 then Mark name should be copied to all those corresponding subject sheets. Similarly at a later stage if I change his subject from PHYSICS to ENGLISH I should be able to do so from the master sheet and his name should be deleted from PHYSICS and copied to ENGLISH.
Hope to get an assistance soon. Thank you.
I wish the students to be assigned to subjects of ENGLISH, MATH, PHYSICS, CHEMISTRY, BIOLOGY, BUSINESS ST., ECONOMICS, COMPUTER ST. So when I type the name of the subject next to the name, his name should be copied to the corresponding subject sheet.
eg. if A2 has the name Mark and I enter PHYSICS in B2, CHEMISTRY in C2, BIOLOGY in D2 then Mark name should be copied to all those corresponding subject sheets. Similarly at a later stage if I change his subject from PHYSICS to ENGLISH I should be able to do so from the master sheet and his name should be deleted from PHYSICS and copied to ENGLISH.
Hope to get an assistance soon. Thank you.
