Auto transfer data as i marked

Solved/Closed
Deb - Oct 11, 2015 at 03:44 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 11, 2015 at 05:54 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 11, 2015 at 05:54 PM
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
0