Sorting and printing help

V

vivekbansal

Pls help me with this problem.

Example:

Table:

Roll No. Sub1 Sub2 Sub3

001 12 14 45
001 15 85 78
002 58 35 98
002 47 25 87
001 45 78 82
002 22 55 66

Now, I want to print the result of roll no. 001 on a new sheet and 00
on a different sheet so that i may distribute the results to student
according to their roll nos.
In other words, sheet one should have rows 1,2 and 5 printed and shee
2 shud have 3,4 and 6.

Maybe, a mail merge command that may print multiple rows .

Pls help.

Vivek Bansa
 
R

Ron de Bruin

Try this

If you want to print it then use Data>autofilter
Filter and Print the sheet for each number

If you want to copy it to a seperate sheet try this
http://www.rondebruin.nl/copy5.htm
The last macro will do this for every unique value in the column
 
D

David McRitchie

Hi Vivek,
If you want a complete set of tools:

Charlie's VBA to Excel to HTML code HomePage Converts an Excel range to an HTML Table, Charles Balch, most formatting is preserved.
Font size, row & column height are ignored. Creates a smaller file than the Internet Assistant in XL95/XL97 and Save As in XL2000
(Tools --> ...). Designed to convert an Excel spreadsheet and automatically place it on the server using FTP. Of particular
interest to teachers in putting grades out to the internet see examples of the macros output in any link to grades in Charlie's CIS
Home Page [href="[URL]http://cis.balch.org/cis/cis.html[/URL]] -- note no passwords are used but the identity of each student is unique.
[URL]http://charlie.balch.org/hdoc/exceltohtml.html[/URL]

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: [URL]http://www.mvps.org/dmcritchie/excel/excel.htm[/URL]
Search Page: [URL]http://www.mvps.org/dmcritchie/excel/search.htm[/URL]

[QUOTE="Ron de Bruin"]
Try this

If you want to print it then use Data>autofilter
Filter and Print the sheet for each number

If you want to copy it to a seperate sheet try this
http://www.rondebruin.nl/copy5.htm
The last macro will do this for every unique value in the column[/QUOTE]
 
Top