$$Excel-Macros$$ Macro - Open PowerPoint and Update Links?

Thanks in advance, experts!! I have a PowerPoint presentation that has links to Excel charts that need to be updated each time the Excel file is changed. I have everything working fine (I can update, save, and close the Excel file, open PP, and it prompts me to Update Links - I click yes,

Re: $$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

I guess I'm in over my head. I have no clue how to use what you just attached. Thanks anyway. On Sep 8, 9:30 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Robert, Please see attached add-in. It will be help to Compare Table. On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs

$$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

Thanks in advance, experts! What I have: 2 worksheets in same Excel file, each has a table (Table1 on WS1, Table2 on WS2) with the SAME headers/type of data. As an example (only), BOTH tables have: Invoice#Cat1SalesCat2SalesCat3Sales TotalSales The only difference

Re: $$Excel-Macros$$ Pivot Table Percent of Column...

: Have a look at the page : http://support.microsoft.com/kb/106359/en-us Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Robert Jacobs Envoyé : jeudi 25 août 2011 16:35 À : MS EXCEL AND VBA MACROS Objet

$$Excel-Macros$$ Pivot Table Percent of Column...

Thanks in advance experts!!! This is very complicated to explain, but I'll give it a go: I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3 Sales), and need to find the percent of sales for each category, for each year in my data. For instance, if I have: Invoice#Year

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

click on a customer name that doesn't belong to the currently selected sales territory, it just shows a blank chart. Help is appreciated Thanks! On May 20, 11:37 pm, ashish koul koul.ash...@gmail.com wrote: can you attach the sample file On Sat, May 21, 2011 at 1:31 AM, Robert Jacobs

Re: $$Excel-Macros$$ Update pivot table filters based on already applied filters?

Well after a bit of searching, it's looking like the Report filters are not dependent. No matter what you select in one report filter, every record is still listed in the other filters, even if they won't show any data when selected. Apparently there's no real way to do this, other than

$$Excel-Macros$$ Filter criteria of one row - show previous row...

Thanks in advance to the expert that can help me I have an excel document with thousands of records, each record has a message associated with it that is listed on the row beneath that record... i.e. Record -SPR Office_Loc 123456 FS_FTW 234567 Message