Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continuing Question
Many thanks Tom.
Just sitting here thinking about it some more ... Regarding the printing: Column "A" contains the dates of entries; is it possible to include into a list, all of the dates (first occurance only) into the list box. Then users can select `from` a particular date and the code would reflect - Worksheets("Data").Range("[cell-of-selected-date]").CurrentRegion.Printout .. Hope that makes some sense. "Tom Ogilvy" wrote in message ... ThisWorkbook.RefreshAll Worksheets("Data").Range("A10").CurrentRegion.Prin tout -- Regards, Tom Ogilvy "Cameron" wrote in message ... I forgot to mention that for Question 1. - I'm intending to create a Button on the worksheet to perform the update. "Cameron" wrote in message ... Hi all, My boss asked to create an XLS that tracks some reporting - done. Then asked if I could create some graphs. I use Excel2003 at home and stumbled across Pivot Tables, and created two tables and charts in the process using the Pivot Table Wizard. Questions: 1. What VBA do I need to refresh the pivot-tables and respective charts if I use this XLS on a PC with Excel-97 ??? **Each chart is on it's own worksheet; the two pivot tables are on one worksheet(PivotTable1 & PivotTable2). 2. How do I print the Data-Source Listing from the first record ($A$10:$G$10) through to the last non-empty record (currently $A$50$G$50, but this will increase). Any help appreciated. Cheers, Cameron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continuing Question
Current region picks up all contiguous cells out to the first blank row and
blank column in all directions (or the edge of the worksheet). So it would not pay head to your dates. Also, it sounds like a single date could appear multiple times, so it would be hard to determine ("[cell-of-selected-date]") in that case. -- Regards, Tom Ogilvy "Cameron" wrote in message ... Many thanks Tom. Just sitting here thinking about it some more ... Regarding the printing: Column "A" contains the dates of entries; is it possible to include into a list, all of the dates (first occurance only) into the list box. Then users can select `from` a particular date and the code would reflect - Worksheets("Data").Range("[cell-of-selected-date]").CurrentRegion.Printout . Hope that makes some sense. "Tom Ogilvy" wrote in message ... ThisWorkbook.RefreshAll Worksheets("Data").Range("A10").CurrentRegion.Prin tout -- Regards, Tom Ogilvy "Cameron" wrote in message ... I forgot to mention that for Question 1. - I'm intending to create a Button on the worksheet to perform the update. "Cameron" wrote in message ... Hi all, My boss asked to create an XLS that tracks some reporting - done. Then asked if I could create some graphs. I use Excel2003 at home and stumbled across Pivot Tables, and created two tables and charts in the process using the Pivot Table Wizard. Questions: 1. What VBA do I need to refresh the pivot-tables and respective charts if I use this XLS on a PC with Excel-97 ??? **Each chart is on it's own worksheet; the two pivot tables are on one worksheet(PivotTable1 & PivotTable2). 2. How do I print the Data-Source Listing from the first record ($A$10:$G$10) through to the last non-empty record (currently $A$50$G$50, but this will increase). Any help appreciated. Cheers, Cameron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continuing Question
Thanks Tom,
Was trying to incorporate some ability for users to print the report from a certain date (referencing back to the cell of the first occurance of that date) to the end of the region. -- Cheers, Cameron "Tom Ogilvy" wrote in message ... Current region picks up all contiguous cells out to the first blank row and blank column in all directions (or the edge of the worksheet). So it would not pay head to your dates. Also, it sounds like a single date could appear multiple times, so it would be hard to determine ("[cell-of-selected-date]") in that case. -- Regards, Tom Ogilvy "Cameron" wrote in message ... Many thanks Tom. Just sitting here thinking about it some more ... Regarding the printing: Column "A" contains the dates of entries; is it possible to include into a list, all of the dates (first occurance only) into the list box. Then users can select `from` a particular date and the code would reflect - Worksheets("Data").Range("[cell-of-selected-date]").CurrentRegion.Printout . Hope that makes some sense. "Tom Ogilvy" wrote in message ... ThisWorkbook.RefreshAll Worksheets("Data").Range("A10").CurrentRegion.Prin tout -- Regards, Tom Ogilvy "Cameron" wrote in message ... I forgot to mention that for Question 1. - I'm intending to create a Button on the worksheet to perform the update. "Cameron" wrote in message ... Hi all, My boss asked to create an XLS that tracks some reporting - done. Then asked if I could create some graphs. I use Excel2003 at home and stumbled across Pivot Tables, and created two tables and charts in the process using the Pivot Table Wizard. Questions: 1. What VBA do I need to refresh the pivot-tables and respective charts if I use this XLS on a PC with Excel-97 ??? **Each chart is on it's own worksheet; the two pivot tables are on one worksheet(PivotTable1 & PivotTable2). 2. How do I print the Data-Source Listing from the first record ($A$10:$G$10) through to the last non-empty record (currently $A$50$G$50, but this will increase). Any help appreciated. Cheers, Cameron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Continuing Formula - try 3 | Excel Discussion (Misc queries) | |||
Continuing Headers | Excel Discussion (Misc queries) | |||
formulas continuing | Excel Worksheet Functions | |||
set up a continuing roster? | Excel Discussion (Misc queries) | |||
Continuing formulas | New Users to Excel |