Unable to create a individual result sheet of student

[mukeshbaviskar]

Hi friends,
I have created a dropdown list for 'roll no.' in cell 'ca8'. I want to display a value of each subject after changing the roll no. in the dropdown list. I want to use indirect function a data validation to bring the appropriate value. Please suggest me how to create it.

I want to print out the result of each student at this time it is very difficult to change a roll no. in the dropdown list. At this time if I give a command of print result then the result should print out from no. 1 to the last no. automatically. At this time the roll no. in the dropdown list should change automatically to keep continuity in printing. Please suggest me a code for it.

The marks from 'bi' 'Marathi' should be in the individual result sheet.

Thank you.

Regards,

Mukesh

[Ron Coderre]

If you convert your data section, BG6:BY14 to an Excel Table, you can just select the Roll NO you want to display.
That will hide the other students and you can print the report.

To convert the range
• Select BG6:BY14
• Home.Format_as_table
...Select a style
...Check: My table has headers
...Click: OK

Is that something you can work with?

[Glenn Kennedy]

I think that this is what you want. It's based on the powerful INDEX:MATCH combination.

[mukeshbaviskar]

Hi Glenn,
Excellent! This much I want to achieve. It solved the first problem but now I want to solve the second problem to print the individual result sheet of each student automatically after giving command 'print'. Is it possible? I will change a file extension 'xlsm' for macro enable file.

While printing the roll no. and the individual result sheet should change automatically. This method save a lot of time to create names in name manager.

Thank you solving my first problem and hope to solve the second and last problem soon.

Thank you.

Mukesh

[mukeshbaviskar]

Hi Ron Coderre,
Thank you for giving me a new idea to achieve the target but the individual result sheet format is is different so it's not possible.

Please think on my second problem to print the result of each student automatically after giving 'print' command.

The suggestion of Glenn is as per my requirement so I like it. Please don't mind. I like your suggestion too but it didn't suit the changed format of individual result sheet.

Thank you for guidance.

Mukesh

[Glenn Kennedy]

VBA is a mystery to me.

Over to others??

[mukeshbaviskar]

Hi Glenn Kennedy,
Thank you and don't mind. Our other vba expert friends will give me a solution soon.

Thank you.

Mukesh

[Glenn Kennedy]

You're welcome... Good Luck!