repeating a vba code in excel

Microsoft Excel 2000
September 13, 2010 at 11:00:28
Specs: Windows XP, 1 gb
hi all

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


See More: repeating a vba code in excel

Report •

May 27, 2011 at 02:56:17
let me see if i understand this correctly.

What you want the macro to do is:

read each Student ID from a list, and go to another worksheet, collect all that users information and save it. and you want this to continue to go through until there are no more user IDs?

Report •
Related Solutions

Ask Question