Search results

Don, perhaps an easier method would be to use the Mail Merge feature in Microsoft Word. You can use or design a template to setup your card layout and then tell Word to create membership cards based on your Excel spreadsheet. I found this tutorial which might be of use to you...

Well wait, that's not entirely accurate. It's true that conditional formatting doesn't exist as a feature, but you can still replicate the feature on your own. Start here, durip: http://peltiertech.com/WordPress/conditional-formatting-of-excel-charts/

Oh, because I agreed with Hui and then sorta changed the subject? I get it. Yeah, most of these posts that happen in forums outside of 'Ask a Question' don't seem to have a lot of staying power. This comment, right here, might even be the last for this discussion. I knew when I made it 2 or 3...

@bobhc What do you mean? Are you asking if the lounge is the best place for it? If it's not, feel free to move it.

Those are all great additions. @Hui, I've been asked if Monte Carlo simulations are possible in excel. I always respond with a link to your tutorial :)

By feature, I don't mean code or formulas. I mean the activities and buttons that Excel provides to allow you to work on, or with, your spreadsheet. For example, I find I use these features all the time: The Camera Tool When I first learned about the Camera tool, I thought "that's neat," but...

@Linwe - thanks!

@Linwe You can either use the camera tool for this or you can use formulas. If you use formulas, the new graph must have a similar axis. The reason is because you are going to share the new type of graph with the same space as the existing graphs. One advantage to using the formulas method is...

P0lar - I'm glad to hear that it's working! I'd be very interested in taking a look at your workbook, if you wouldn't mind posting it here. You can also handle interactive hyperlink "clicks" without the Worksheet_SelectionChange. I've written about that, here...

@NARAYANK No problem ;) One last link in case this conversation becomes referenced later. I think Robert Mundigl provides an expert tutorial on the rollover method far better than I ever could...

I can't imagine non-automated way of knowing the date of the last input without some VBA. You could use NOW() as a formula in Excel (for example, "=NOW()"), but every time there's a calculation, the formula will update to the most current point in time. If you do not want to use VBA, then you...

I would probably add a timestamp to every entry and then look for the last entry in your database upon opening the workbook. For every new entry into your database, you might try something like: ActiveSheet.Cells(currentRow, timeStampColumn).Value = Now Obviously, you can replace currentRow or...

There's also a Google Drive with more examples of the technique: https://drive.google.com/#folders/0B1OBNnu3ZbL0UVFzLWx1OXk3VEU

It definitely feels like marketing hype. Our datasets are definitely getting larger as Hui points out, but I don't think the way we analyze data has actually changed because of it. By the way, I met Stephen Few a few weeks ago and got him to sign my copy of Information Dashboard Design.

You could do a mouse roll over, but that may be a bit more intensive than you require. I believe the easiest way to implement the functionality you desire is to use a form control checkbox. As you may already know, checkboxes can be connected to a cell on the spreadsheet. When the checkbox is...

What's the consensus on Chandoo of "big data"? I'm still not convinced that big data is anything more than marketing nonsense, an attempt to repackage the same-old as something new and flashy. The same could probably be said for "business analytics/intelligence," which used to be called OLAP...

That's so weird. I'm interested if a reinstall fixes the problem. Keep us posted!

Try: http://www.accessmvp.com/JConrad/accessjunkie.html and http://www.accessmvp.com/djsteele/AccessIndex.html

Your code also works fine in my version of Excel 2010. Like others have indicated, if you could take a screen capture of the error - or describe the error in text - that would be helpful toward diagnosing the problem. Alternatively, you might consider this tutorial...

We have Heineken. I recall Carlsberg tasting about the same. We also have bourbon - and lots of it! I can survive off bourbon.

Start here, my friend: http://www.ozgrid.com/Excel/DynamicRanges.htm

Yuck - very low on the beer factor.

Maybe I'll hire an intern to hang around Chandoo all day and open my beers for me. Some bad news: Where I live in the States, there is no Carlsburg.

When I have break during the work day, I'll come here to see if I can help answer some questions. You guys do such a good job that virtually ever question goes answered. And they're quality answers too! - unlike the ones I'd provide ;). Keep up the good work! :)

That's a dangerous gamble, my friend.... :)