Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing a table based on a larger table
I have a table on a sheet with columns as shown: (These are in order of PartNum, ascending) A B C D E ... O PartNum PartName JanSales FebSales MarSales ..... AnnualSales. I need to be able to print out individual reports with columns as shown below: (1 report for each month and 1 annual) A B C PartNum PartName JanSales Also, these reports must be printed in order of column C, ascending, Now, I can do this 'manually' (copying, pasting, sorting...), but I was really hoping to automate the process. I'm new enough to Excel that I'm really looking for a good way to proceed. Is it best to put the monthly reports to be printed on the same sheet as the parent table? Since the monthly reports all have the same structure, should I just make one table that is filled by,for example, clicking a JanButton? I need a push in the right direction. VERY GRATEFUL for any assistance. (have a tight deadline!) Cheers, Bri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Calendar based on varying information/ Pivot Table General | Charts and Charting in Excel | |||
Printing a Pivot Table from code - Excel 2003 | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Pivot table help:calculated field based on previous consecutive va | Excel Discussion (Misc queries) |