But, there are some columns that i dont want to be shown on the print
copy.Do i hide treh column?

Can you use vba code in the workbook
You can create a button then that do the filter, hide the column and print
Bed time for me now so I reply tomorrow



And also, thre print copy has to have teh sum of teh total value, i.e.
the sum of all the items bought by the customer. Anything else taht we
can do abt that ?

See the Excel Subtotal worksheet function
=SUBTOTAL(9,E1:E200)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Newtonboy" wrote in message
...

Suupppeerrrrbbb Ron ! Thanks !

I chked after activating the filter function, I could print it easily.
But, there are some columns that i dont want to be shown on the print
copy.Do i hide treh column? But, doing it everytime would be error
prone wudn't it ? Coz my staff would be doing it and their computer
skills arent too great, neither are mine !

And also, thre print copy has to have teh sum of teh total value, i.e.
the sum of all the items bought by the customer. Anything else taht we
can do abt that ?

Thanks,
Ajit


--
Newtonboy
------------------------------------------------------------------------
Newtonboy's Profile: http://www.excelforum.com/member.php...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=558163