| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Specific data from Excel worksheet
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Printing Specific data from Excel worksheet
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add link to specific Excel worksheet in HTML Outlook message | Links and Linking in Excel | |||
| how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions | |||
| Importing Data | Excel Worksheet Functions | |||
| importing data from Excel worksheet to another worksheet | Excel Worksheet Functions | |||
| Excel link to data in other worksheet only refreshes one column | Excel Discussion (Misc queries) | |||
Hybrid Mode
