I have attached a part of the table that I reffrence for my overviews This table I sue as my source for graphs information, fileter by year, month...
What's the 007 or the 008? Is that a counter? What does that have to do with the date?
Hi Martin, I'm sure you understand what you are asking but without a sample you will not get an answer. If we give answers based on assumptions ...
There is no calculation in what I showed you, the only thing I said was that if you add the formulas to your downloaded source data you can then use i...
I'll have to take a deeper look at the way you have your data. What I did with the table where all source information is stored is add a number of ...
I have a similar set of data and what I did is create a dashboard sheet that reads the data. I cannot share it since it's too large and contains ou...
Well, you coul start with recording a macro and then edit it to your needs. That way you can see how the code is built up. What's you excel vers...
I'm not sure as of which version SUMIF was first introduced but the simplest way is to understand how it works and then you can write your own custom ...
I would suggest you base the duration using the current data if there is nothing else
Hi Esteban, You can use two cells: When the VBA routine is triggered. Some thing like this Your macro worksheets(xxx)Range(whatever 1) .va...
Riny gave you the answer, but if you want to do that froma file elsewehere on the netwrok you will have to program a macro thet is triggered at a inte...
Sorry for budding in, but this forum (and (two) other ones I checkout, help wher I can out or post questions) is exactly for that. You can ask, anyon...
@Mynda: great dashboard
I suggest you contact the site where you got the file from. Password cracking is not an option and there's probably a reason it's protected
I don’t understand what you want but maybe the macro can help you work it out, it’s quite simple to include exclusions and actions, you z’n Taylor it ...