• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Simple macro to copy data with criteria

    Exactly what i wanted Hui THX!!!
  2. D

    Simple macro to copy data with criteria

    Hi all im trying to create a macro that will copy data from source data to a new sheet when the data in column B=A, this is what i have come up with but gives errors ; where am i going wrong ? THX Sub copytoworksheet() finalrow = Cells(Rows.Count, 2).End(xlUp).Row For i = 1 To finalrow If...
  3. D

    Create Pivot Chart from with just one item from the pivot table per week

    Hi Narayan, No this shows the % of Closed on first call in compared to the whole month What i'm looking for you can already see in the highlighted cells in My sheet. The % there are correct %of all valid closed tickets that have status Closed on first call. Problem is when i create a...
  4. D

    Create Pivot Chart from with just one item from the pivot table per week

    Here is the Link: http://www.mijnbestand.nl/Bestand-MQEBYBKIYP7E.xlsx Thanks
  5. D

    Create Pivot Chart from with just one item from the pivot table per week

    Hi Narayan, No i'm afraid this doesnt give me the correct value. I can send you an example excel sheet maybe that will make my question more clear If thats ok with you
  6. D

    Create Pivot Chart from with just one item from the pivot table per week

    Hi Narayan, Almost problem stil is when i filter the data in the pivot table the % calculation is only done on the data that i have filtered instead of all the data. So when i have 2000 records of raw data en filter the "Closed on First Call" field i get 100% and i would like to % of closed...
  7. D

    Create Pivot Chart from with just one item from the pivot table per week

    Hi Narayan, Thanks for your reply i probebly wasnt very clear its not exacly what im looking for. The problem is when i create the chart (its fine that its a pivot chart) I get all the Closed statuses in the chart (i'm not supprised ;-)). I just want a pivot Chart with the weeks and the...
  8. D

    Who has some great examples of SLA dashboards

    Hi, I'm creating a dashboard with basic servicedesk SLA data. Anoyone out there with some examples of a dashboard were service management tooling data whas used raw data. Thanks DD
  9. D

    Create Pivot Chart from with just one item from the pivot table per week

    Hi All, I've created a Pivot table with the closing status of an SLA report. I would like to create a Chart of just the "Closed on first call" status per week. See the exampel data below. What would be the best way to do this. Thanks!!! 201135 100% Closed Invalid 1,16% Closed Not...
  10. D

    Importing awkward data

    Thanks asa! The MrExcel sollution workes great. I will have a go at the VBA just for the fun of it, if i cant work it out i'll know were to go :-) Thanks again like John said first class answer! Dannis
  11. D

    Importing awkward data

    Hi Guys/Girls Could anyone tell me how i can import the folowing data into Excel. just 2 records here loads more (duh), i would like to create a nice table with category, Code, ect. Thanks All Category: NL.Dannis.Test Code: Dannis01 Last Modified: 28/07/2010 11:30:12 By: D...
Back
Top