Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Blogs

  • Sync Pivots from dropdown

    Over at the Excel Guru forum, Yewee asks: I have 3 sheets in my excel worksheet. 1. Org 2. DataSource 3. Pivots Table My Pivot table will get the data from the DataSource sheet. I will like to have the filter of the Pivot Table from one of the cell in Org Sheet. How can […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 16 2014
    Filed under:
  • A couple of quirky bugs…

    Found a couple of funny bugs today that I thought I’d share. First, this one:     Weird: Partially italicizing right-aligned text screws with the display of trailing spaces. But it doesn’t do the same to left-aligned text with leading spaces:     And then there’s this one, where you start with a file that […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Aug 15 2014
    Filed under:
  • Articles about installing softwares from SamLogic

    I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable. Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important […] Read More...
  • More AutoHotkey Sugar

    Ken Puls, the Excel Guru, sent me some nice AHK stuff and I’m trying to put a post together to share it with you. But it’s not happening so far. In the mean time, I didn’t want you to have to wait for these gems that I’ve been enjoying. Definition and Last Position in the […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 12 2014
    Filed under:
  • One of these things is not like the other…

    Sometimes when I copy code from the web and paste it into VBA, I get something like this:     …and I’m damned if I know why. It’s not the usual culprit of incorrect quote marks. It’ something else, and I don’t know what. Usually I just retype the offending line:     …and after […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 9 2014
    Filed under:
  • Formulas for Sale

    101 Ready to Use Excel Formulas It’s for sale. If you pre-ordered, it’s probably on the way. If you didn’t, well, you know what to do. I got my copy last night. My wife, who is not an Excel geek by any stretch of the imagination, is excited to read it. At 240 pages, it’s […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Aug 6 2014
    Filed under:
  • Slicers and SlicerCaches

    Behind the scenes, Excel does quite a bit of smart rationalisation in terms of SlicerCaches whenever you connect Slicers to mulitple PivotFields, and this can be a bit confusing if you’re not familiar with what’s going on. So let’s take a look-see. First, let’s create three PivotTables all based on the same data source – […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 5 2014
    Filed under:
  • Formulas? Pah!

    Welcome back to Twice Daily Dose of Excel. Heck, these days we’re more regular than Julian Assange’s visits to the Ecuadorian Embassy! Audrey has a table that looks something like this (if you’re American): …or like this (if you live somewhere sensible, like in New Zealand and a good deal many other places besides): She […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Aug 4 2014
    Filed under:
  • Centennial Weekend Birthdays

    On this episode of the BBC’s More or Less podcast, they discussed big, round birthdays that fall on a weekend. A listener said that she had to wait until her 60th birthday for it to fall on a weekend. The guy who figured out how unlucky she was tested every birthday from January 1, 1900. […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Aug 4 2014
    Filed under:
  • Dynamic Vertical Line on a ScatterPlot

    GMF comments: I use XY charts for schedules and I like to have a vertical line showing today’s date. I do this so frequently I have a named range for each of the X and Y values. To get the current date to show up as 2 similar X values the best I could come […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 2 2014
    Filed under:
  • Listing Calling Procedures

    I have this awesome machine with 64-bit Office sitting under my desk. I don’t use it to code because MZ-Tools doesn’t work on 64-bit Office and I need that (and a few other things) to be productive. I only use a few features from MZ-Tools, so I think I’ll just write them in VBA. I […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Aug 1 2014
    Filed under:
  • Quickly changing or deleting Named Ranges Redux

    I know a good thing when I see it. Dick’s use of the word Redux in yesterday’s post for one. Dick’s nifty CreateDynamicNames() sub for another. Put them together, and you’ve got a winning combination. Or at least, 5 minutes of distraction between whatever the heck it is you’re supposed to be doing instead of […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Jul 30 2014
    Filed under:
  • Listing Conditional Formatting Redux

    Back in the day, I posted some code to list conditional formatting. It didn’t contemplate having multiple conditional formats for the same range. Because who would ever do that right? Of course that happens all the time and was very short-sighted of me. I aim to atone. I used a Collection object because Collection objects […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Jul 29 2014
    Filed under: ,
  • Quickly changing or deleting Named Ranges

    One thing that’s always irked me about working with Named Ranges is that while you may have selected the cells that a particular Named Range points at and can even see that name in the Name Box… …you can’t do anything actually useful to it – such as changing where it points too or deleting […] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Jul 28 2014
    Filed under:
  • The Garage Series for Office 365: What’s new in the world of apps for Office?

    This week hosts Jeremy Chapman and Richard diZerega explore what’s new in the new world of apps for Office. They look at the top 5 new features including amazing content apps for PowerPoint, Excel APIs for formatting, content apps for Access, mail APIs for body and attachments and compose mail apps. Watch as Richard masterfully demonstrates all of this along the way. Last week we caught up with Jeremy Thake… Read More...
    Posted to The Excel Team Blog by Office Blogs on Wed, Jul 23 2014
1 2 3 4 5 Next > ... Last »
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.