Search results

Hello, I created a simple measure (PowerPivot) to determine if a unit met a time goal of 200 seconds. =if(apparatus[Min Incident Time] <200,TRUE,FALSE) What I want to do next it to create another measure to figure out the percentages of true and false in the column. I attempted the below...

Hello, I'm setting up my data model for a power pivot project and it looks like my look up tables are being used as the main table. The Incident Table is my main table. The incident Key is my primary key between the EMS Scene, Apparatus and EMS advance, but the arrows and relationships seem to...

Hi, I am very close to finishing this whole project, but I need one last tweek. I recieved help last week for the below code. The only trouble is I want to keep the values and formatting of the original worksheet. I tried: owb.Worksheets(1).Range("A1").PasteSpecial 12 But that must be...

Hi, I have a few ideas about this, but looking for a push in the right direction. My workbook (redacted) contains a list of 10 people (hundreds in working copy) that I want to send their fitness results to. My main data worksheet is worksheet (1) and it list all of their results. Worksheet...

Hi, I received this code from a previous question and it worked perfect for another project. I started a new project today and it only pulls the first value, exits the loop and then I get an error when it tries to save over the same file. It only copies one row, then exits the loop. I have...

Hi, I'm running a macro that opens each workbook in a folder, collects the email from a cell, attaches the workbook and emails with a gmail account. I have stepped through the code and it looks like all my variables are correct, but I get an error on adding the attachment. I've looked through...

Hello, I am using this formula to count the number of unique values in a masterlist. Since I am also counting the heading, it returns the next number I can use as a document unique ID# when I create a new document. (There are two visible worksheet in attached workbook. The below formula is in...

Hi, I have a very simple piece of code that copy/paste a range into a body of an email. It works just fine with the exception of the form control. I have a combo box that overlays E3 and it populates the value in E3. I don't want to see both the value in E3 and the combo box as it is showing...

Hello, I should know how to do this, but I am coming up blank. I attempted to do in a pivot table, but thought a formula would be better. I have a list of employees that work each day. An employee maybe listed more than once during the day if he/she was split into another work area. I can...

Hi, I have googled and searched the chandoo's website, but the only solution was from the "techguy's blog" and it was removed. I am clicking inside my pivot table, but the fields menu in the upper tool bar won't show. I can't figure out how to get into my pivot table and changes fields and...

Hello, After reading Chandoo's posting on "Finding a Zip Code" with the new formulas in Excel 2013, that got me thinking. I have a list of several hundred addresses that I would like to find the lat and long for each one. Can this be done? Thanks, Brent

Hello, I applied conditional formatting with the attached document so that any time greater than 5 min 20 seconds would show a yellow side wards arrow. Works great, but instead I now need to set time for each pivot row category. I have a total of 7 different metrics which each one having a...

Hello, I may be making this more complicated than it should be. I want to sort my table based on the F Column which will have a dynamic range (also could have empty columns within the table). I think my error is with ws.Range("rng") Area of Code with Error: ' ws.Range("L2").Select...

Hello, I am getting an error with my code and I am not sure why. I think it is because the sheet is not active, but unclear. Error happens with this line: ApprovedSheet.Cells(2, 5).Select The "Import" worksheet is the active worksheet at the time Thanks, Brent Option Explicit Sub...

Hello, I have place this code into the sheet name that contains my pivot table, but I can see it is skipping to loop. Not sure if it is because I am using Excel 2003 with this project. My goal is to have the pivot table(s) refresh in the worksheet when the user activates the worksheet to view...

Hello, I am getting an error code with this line and not sure why. I am new to loops, so there might be more wrong than I realize. iRowStart = ImportedSheet.Rows(2) ' This should Row 2 (first row has headers) My code is looping through the "imported" worksheet and then copying the...

Hello, New to VBA, just finished Chandoo's VBA Course. I am missing something after I find the last row and last column of the data I want to import. I find the last row and last column, but I am not copying it. Confused on that portion of the with Statement. I also have an error when I...

Hello, My chart is fed by Array Formula which shows a dynamic list in my chart. I have tried changing "" to N/A to show N/A in the formula, but it also ends up as a category. There are places on my X axis even though there are no values, just the formulas. I have tried the formatting to the...