Student's grading system

**imranlah** · 12-18-2010, 05:08 AM

helo,I'm trying to create a simple excel grading system for student. this excel file have been mail-merge to word to create individual certificate. i have created a table using mail merge to word certificate using values from "grade" and "status".

the problem is, i want to display only rows ("subject") that have value in "grade" and "status" column. is it possible to delete the entire row (subject") that have empty,n/a or null value in "grade".or is there any workaround to this problems.

empty "grade" and "status" means the student did not took the subject. i dont want to display an empty subject with no grade and status.

please take a look at my file http://www.datafilehost.com/download-a1c750dd.html..i'm new to excel and word,so any modification to the file to make it simpler is most welcome..thank you.

**Richard Buttrey** · 12-18-2010, 06:05 AM

Hello and welcome to the forum.

Why not just use Data filter to filter the table(s) for the values you don't want. But first you appear to have 3 discrete tables and some lookup ranges so move each of these to its own separate sheet. It's always a good idea to keep these things separate from one another. Use Cut and Paste and you'll preserve the various links.

Then you can do your data filter on each table and when filtered just select and delete the rows.

HTH

**imranlah** · 12-19-2010, 05:08 AM

thanks a lot for the tips..data filter really helps me a lot..and i have tried to mail merge the separate sheet but it doesn't work. Seems like mail merge only works with a single sheet. Also excel does not support primary key function like database,so any redundancy will be treated as a different data in mail merge..eg: field 'name' in different work sheet,although i linked them between sheet,mail merge sees them as separate data ..please correct me if i'm wrong ..

I prefer to use 'mail merge' than 'insert database' because i can easily pull out individual data for printing. But the problem is i have to manually create a table in word to placed data from mail merge. I have tried the insert database function but seems i need to know programming to pull out individual data for printing. so mail merge is much more simpler..good thing about insert database is it has table and grid built in function. again correct me if i'm wrong..

and final question.. if i created a table in word,can i make the table automatically delete entire empty/blank row?eg: mail merge pulls out 2 rows of data ,the 3rd row is empty or no data. i want the 3rd row to be automatically deleted.

i'm still learning to how to use excel and word..please give me good alternatives and suggestions..and sorry for my poor English

...

**Richard Buttrey** · 12-19-2010, 06:04 AM

Hi,

Can we step back one pace and ask a simple but obvious question. Why do you need to create the certificate in Word? Wouldn't it be much simpler to design a template form in Excel with (probably) iVLOOKUPS and then just use a simple macro to successively work down a list of names, and automatically populate the certificate each time before presumably printing and/or saving?

Regards