Recent content by Dandas

For anyone interested I fixed it by adding the following code in combination with my Formula in a Named Range which is "ChartFormula". Sub UpdateChartSourceData() With ActiveSheet .ChartObjects(1).Chart.SetSourceData _ Source:=.Range("ChartFormula"), _ PlotBy:=xlColumns...

Also, I have tried to just add a name in Insert -> Names -> Define and added the formula to the name but it does not stay there. Every time I change the days or number of agents the graph does not update and when I go into the graph the formula does not refer to the name, it just has the...

Hi Glen. Thanks for that. I actually tried that but found that by putting the formula in a named cell it tries to return the result of the formula. Since the range takes up many cells it comes back with #VALUE! I also got some code off google to craete a function that displays the formula...

Hi guys. I haven't posted anything here for years so sorry if this has come up before. I have a report in excel used in a call centre that tracks the number of calls an agent makes. Team Leaders want to see performance by month on a chart. I have a chart that has an offset formula to change...

Hi. I have Win XP Home (I know its not pro but I couldn't find an XP home forum) and I have a wierd problem. With some of my applications, when I open them they flash up for a second and then close down again automatically and I can't get them to stay open. The applications are completely...

Anyone come up with any ideas the last few days?

Ok. This is the run down. I do the reporting and statistics for a call centre and the agents are measured on things such as the time spent working on calls, and after calls. We are using a Rockwell switch and it is very smart and records every single thing that happens, including touchpad...

Only thig is I need to look at a) while I am at c). In the below example I need to be able to write a formula that says "if a is "unavailable" or "available" (there are numeric codes for each of these) then display that state next to c)" a) Available b)...

LOL, sorry I confused you. I put the "X" there to show you where the cursor stopped when I got the error message. It is saying that where the X is, the system is expecting a variable name. Hope this makes a little more sense. Thanks

The simple things are usually the ones that get me !! Thanks for that. Now I am having trouble with the second part. I have copied Dgillz formula straight over and replaced it with my field names and I get an error message saying "a variable name is expected here" and the cursor...

Hey Dgillz thanks for your response (and sorry it has taken me so long to get back to this - my boss threw a new piece of work at me). I am totally unfamamilliar with using variables so I just copied your text and pasted it in, and changed the {YourFieldName} to my field name which is...

Hi. I need to compare a cuurent record to a record 2 records back. Obviously I can get 1 back by using the "previous" command but I don't know how to go further. I tried to create a calculated field @previous1 and then take a previous of that field by creating @previous2 but it did...

Guys...... I LOVE YOU !!! It worked, It is totally perfect now. You all totlly rock !!! Thank God for TEK-TIPS

Anyone have any new suggestions? Thanks

Ngolem: I forgot to mention I used your formula and it did not make a difference that I could see.