claims

Hi All, How do you deduct 1 row from the last row selected using ctrl+shift+down? In this way, I won't be including "Grand Total" to the graph that I will be creating. Range("A5").Select Range(Selection, Selection.End(xlDown)).Select <colgroup><col width="305" style="width: 229pt...

Hi All, I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for...

Hi All, How do you remove a row with "(blank)" from a pivot table which is also producing count for blanks? VBA <colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 9760;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt...

I've been driving myself crazy this morning trying to make this work, but I know someone here can point me in the right direction. I have some premiums collected sorted by month received on the horizontal axis and three breakdowns for the premium in column D. I would like to sum these for each...

Hoping someone can help. I am trying to match a name Column A for payments between 2 date ( Quarters- ie January 1st 2019- March 31st 2019) If the criteria match I need to know how many claims and the total payment for claims for that person in the quarter- There is generally more than one...

Hello, I apologize in advance because my question is going to be vague. A year or so ago a collegue sent me an excel workbook which had the ability to click on certain fields wihtin the summary page and the data related to that cell would break out in a new table on a new tab. I have a list of...

Hi there, Trying to get a total count of past due claims based on a due date specified in a cell. Each due date for each claim is different. Here's a screenshot of what I'm working with: So basically, I want it to look at the "Due Date" column (H3:H53), compare it to the "Compltd" column...

Hey everyone, I'm trying to use a vlookup with an if statement so when I choose a company from a drop down list information will automatically fill in. <tbody> Drop Down Claims SL Prem CF Exp. 2013 =vlookup(drop down,...?) 2014 2015 2016 2017 2018 Total...

I have a spreadsheet that has columns for total claims by subscriber and the % of overall claims the subscriber has for the group they are part of. I would like to sum up the total claims column based on either of two conditions being met. If the total claims are greater than a certain...

Hi there, Recent issue I've noticed in pivot tables in Excel 2013. When I go to explode data I am getting different results than I want. <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> Row Labels Claims Open Claims New Claims New Ind New Lit New...