agency

I'm attempting to capture an array from filtered results to then use later in a filter. I tried following this logic but cant figure out how to change it to my needs since I'm only using one sheet. https://contexturesblog.com/archives/2010/12/15/excel-autofilter-with-criteria-in-a-range/...

I have a pivot table that draws it's information from an external cube. One of the fields in the pivot table contains an agency name and number. The agency number can be anything from 1 to 4 digits. It looks like this: INSURANCE AGENCY (1234) Is there a way to extract the number from the field...

I have tried to adjust a VBA Code that was built for me by Fluff and I thought I was close to getting it to work, but I was mistaken. Sub Kyosti() Dim Cl As Range Dim Ws As Worksheet Dim Ky As Variant Set Ws = Sheets("Data") With CreateObject("scripting.dictionary")...

Hello, My title isn't the best description, but this is what I'm look for and a link of the data. I am looking to have a Macro create a drop down menu (or some other way to make the selection) on worksheet "Agency" with 7 unchanging options. Location 1, location 2, location 3, location 4...

Hi help with this formula please? =COUNTIF(ZERO!BH:BH,"Y",ZERO!J:J,"*Agency*) Basically I only want it to count if Column “ZERO!BH:BH” hasa ""Y in cell and if Column “ZERO!J:J”includes the word Agency in the column The above formula, excel says there’s too many arguments? Thanks in advance

Hello, I have an Excel spreadsheet that contains the following columns: AGENCY FORM_NUMBER TYPE_DESCRIPTION DEFAULT_SIDE FORM_CREATE_DATE COUNT(*) AGENCY 1 1...

Hello, I was given a file to clean up. It has over 15,000 address entries in a row format: <tbody> ID Agency 201 Name Address 1 City,State, Zip Phone # </tbody> There is an id number assigned in the cell in column A at the Agency name. All the address fields start in column...

I am working with a macro that looks at a workbook and then saves the individual worksheets to their respective folders. What I am trying to do and what I can't seem to get figured out is saving the worksheets to another level in the file path structure that is the a date folder - mm-yy. So...

Hello, I am stumped. In my work I use excel spreadsheets for billing with sub-contractors that provide employment services to people with developmental disabilities. I would like to track “how long it takes an agency to find jobs for customers”. In my spreadsheets, I have a line for each...

Hi all, I need to count the number times certain text appears in a column between variable rows. Really struggling to find a way to do this and any help is appreciated. So in the example below How can I count all instance of "3.5 Tonne" if it appears between the labels "Gas installer" and...