PDA

View Full Version : Print detail and summary report



sujittalukde
12-26-2007, 03:54 AM
I am attaching a sample workbook wherein I want that if the user clicks Print Detail button then the code should print all the records and shall hide those columns wherein no data exist for both DR and CR
If the user clicks Print Summary the it shall hide the colored rows and shall print the rest and and shall hide those columns wherein no data exist for both DR and CR

In case there is any designing problem for the code please suggest me so that I can use the same for my project. Please note that the rows are more in my actual project .

I cant use subtotal or pivot table as it is a part of an overall project.