i had a worksheet for entering data and as well as calculation. e.g. if i enter the ID of a student, it will fetch the relating datas of the students including his/her marks in different sujects. then it will calculate his/her grade, % etc. then if i run a code it will save the file in a desired location.
i had another sheet containing the students IDs.
can LOOP or any other statements be used in such a way that if i rua a macro, it will call the student IDs from that sheet one by one and save each sheet.
i dont know wheather i made u understand or not?
waiting for response