Auto transfer data as i marked [Solved/Closed]

Report
-
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
Hello,
I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related. They are submitting assignments in every six months and now i want to ask a question that if i marked '/' in a cell after subject code, is it possible that the particular student name & enrolment No. automatically paste in the other spreedsheet under the particular subject code. Pls inform me.

1 reply

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
it can be done. rather have it done on fly as you type "/", have a marco that you can run when ever you want to move the data to new sheet