Hello everyone,
this are the testing format for my excel project
SHEET 1.png
from the sheet 1, i already key in all the data
but,
SHEET 2.png
how can i link example -
sheet1 a2 (student id), a3 (name), c13 (total mark), and g7,8,9,10,11 (grade) to auto fill in sheet2 according to columns line, but after it fill up to sheet2 the sheet1 will be empty and start for new student id,name,marks and grade
is it possible to do that formula?
Bookmarks