Auto transfer data as i marked [Solved/Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!