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...
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...
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
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...
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...
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
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...
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
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...