Sorting and printing help

[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

 

[Jack Schitt]

Probably not the best approach, but I would:
set the page area to embrace the whole database.
Autofilter the database
then a little macro to autofilter by each Roll Number in turn, and print it
between each selection in the loop.

 

[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

 

[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]

--


[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]