watch inside wikileaks online dating - An error occurred while updating the entries

We want to look at the currently selected Report Period (a named range called Report Period) and find the value for each metric that is in the same row as that report period.

That will give us the “Current” value for each metric.

an error occurred while updating the entries-22

We’ll name the cells in the first row of each metric column (the row labeled “Current– to be named cells, but it makes for easier, safer updating of the dashboard as the complexity grows).

Name each cell by clicking on the cell, then clicking in the cell address at the top left and typing in the cell name.

It’s important to have consistent naming conventions, so we’ll go with _Current for this (it works out to have the metric identified first, with the qualifier/type after — just trust me! The screen capture below shows this being done for the cell where the current value for Orders will go, but this needs to be done for Revenue and Web Traffic as well (I just remove the space for Web Traffic — Web Traffic_Current).

And, of course, we’ll actually need data — this would come later, but I’ve gone ahead and dropped some fictitious stuff in there: That’s it for the Data tab for now…but we’ll be back!

The single post on this blog that has, for several years now, consistently driven the most traffic to this site, is this one that I wrote almost three years ago.

Apparently, through sheer volume of content on the page and some dumb luck with the post title, I consistently do well for searches for “Excel dynamic named ranges” (long live the long tail of SEO! The kicker is that I wrote that post before I’d discovered the awesomeness of Excel tables, and before Excel 2010 had really gone mainstream.

It can be a bit of a hassle on the initial setup, but it will pay huge dividends as the report gets updated each day, week, or month. Before we leave this tab, go ahead and select a value in each dropdown — this will make it easier to check the formulas in the next step. We’re going to go back over to the Data worksheet and start setting up some additional named ranges.

We’ve got Main_Data, which is the table that includes the full range of data.

I’ve been meaning to redo the original post with an example that uses tables, because it simplifies things a bit.

This is that post — 100% plagiarized from the original when it makes sense to do so. However, it should work fine on Excel 2007 for Windows, too.

Let’s leave the first row alone — this is where we will populate the “current value,” which we’ll get to later.

Tags: , ,