state

  1. E

    Tender Transaction

    Hello, I have created a userform but am having trouble figuring out how to input the code. I want it to input the values that are typed into the form but only the ones that have values. It would be great if it could also state what the tender is i.e. cash, debit... etc. Any help would be...
  2. S

    Excel Sub in Form doesnt seem to be working

    Below is the code I have been working on for a form I have created for work. Basically to make sure nobody is taking the @##@ and targets are beings hit. Private Sub bClear_Click() With Me .cbSeanProactive.Value = "" .cbSeanMailbox.Value = ""...
  3. J

    Display all companies of a state, when the state is selected

    Hi, I need to see the list of companies and associated details when I select a state. Please check the table I have and the desired list. List I have: <colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> s1 s2 s3 s4 s5 s6 s7 s8 s9 s10 name...
  4. M

    Pivot Filter Based on Cell value

    Hello everyone - I've searched through some posts but I am a vba amateur and I can't seem to make things work for me. I have a pivot table on a tab called "2017 Summary" There is a single filter for this pivot - by state. There is a drop down with 19 state abbreviations. The cell range is...
  5. E

    Selecting row then closest value from it

    Hello, My data set has rows that are states: IA, IL, MN, MT, ND, NE< SD, and WI. Each column is a percentile: P1 - P100. I have a value and a state, I want to look-up the state and return the closest value. I have been running into issues because I have not found any formula that will both...
  6. R

    Turn part of a list into a table

    Hi, I am trying to turn a text list into a table. The list is approx 60 'routes' as similar to below. I would like use a macro to turn this into a 60 row table. What is the best was of achieving this? Many thanks, Rich From a text list:Route *TEST_AD* User 1 name: Business Unit...
  7. K

    Seemingly simple dynamic drop down list question

    Hi all, Hopefully there is a simple way of doing this, as I feel embarrassed that I have failed to this point. A simple example would be a table with three columns - State, County, and City with 500 records (500 unique cities, 100 counties and 50 states) I need thee drop downs, each based on...
  8. S

    combining 2 excel sheets into 1

    I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...
  9. N

    Macro Export Question

    Hello, I created a macro in Access to run a query with a date parameter and a field that concatenates the city, state and zip fields. When the query runs and completes, I can see the concatenated field as I should and the city, state and zip are unchecked in the query to be invisible, but...
  10. B

    How to fix a #Type! error

    I have a report that is based upon a query where I'm getting the dreaded #Type ! error. All the query in the report shows up as it should but when I go to the report (which is comprised of 3 fields in the detail) I get this error in two of them. In the header row, I have State Council Positions...
  11. E

    Index/Match and return header

    Hi i would like some help with returning column headers based on the highest value in the specific row that will change constantly. Much appreciated! An example would be: <tbody> <tbody> State 16/08/2017 13/09/2017 20/09/2017 27/09/2017 04/10/2017 11/10/2017 18/10/2017 20/10/2017 1...
  12. N

    VBA loop to lookup state name

    Hello, I'm trying to build a macro that can automatically look at a state abbreviated ID (TX, KS, NY, etc.) in a single column and return the full state name (Texas, Kansas, New York, etc.) in a blank column to the right. I need to be able to use this macro in any workbook, as I will refer to...
  13. J

    Excel Macro

    I made an excel sheet that has 5 tabs. I put info in one tab and the others pull information from that tab to populate cells. That way I don't have to type things in multiple times like address, name, etc. This is working great. To make this even better I was wondering if there was a way to run...
  14. S

    "ALL" doesn't seem to work when I have filters inside my query

    I'm trying to do a time series line chart where I have 3 lines: 1 line for "Plan" state performance, 1 line for "Forecast" state performance. I have a main slicer that I can toggle for various states (i,e TX, AR, etc etc). I also want one more line, that is the "National" line, which is the...
  15. avisoft20

    Count if with multiple condition.

    <tbody> Dear Sir, I want to count state wise status of billed or not billed,i am applying countifs but its not working. Example SHEET:1 <tbody> State Status ASSAM BILLED ASSAM NOT BILLED ASSAM BILLED CHANDIGARH BILLED CHANDIGARH NOT BILLED </tbody> </tbody> ANS: <tbody>...
  16. J

    Help in Linking Excel data from different excel files.

    Hi Everyone, I have a problem with the below table. Request you to please help me. There are 2 sheets. 1st Sheet contains predefined details mentioned below Row 1: Product Name / Details Row 2: Price for State 1 Row 3: Price for State 2 Row 4: Price for State 3 2nd Sheet is a Daily Report...
  17. T

    Creating a survey results calculator in Excel - a bit complex

    Alright, Excel gurus, I could use your help. I've got a bunch of survey results, and I'm expecting lots more. I'm creating a calculator in Excel to run some numbers for me faster. The main problem I'm running into is that the result I'm ultimately looking for is an average salary amount. When...
  18. E

    SUMIFS in VBA

    I have an Excel userform wherein the user selects a member number from a combo box, a state from a second combo box and one or multiple counties from a list box. I then have a "Calculate" button that I want to sum the number of members in the selected state and countiesr. There can be just one...
  19. B

    Comma or State showing up in Concatenated field

    I have a formula that combines the city, state and Zip fields in one field called CSZ. I want to show nothing in that field if there isn't an address provided But, if the address, city, state, or zip fields are null, I will get a ", " followed any field that may have something (e.g. ", CA")...
  20. K

    Filter all but one middle row

    I have a list which I would like to be able to filter while leaving one merged row/cell in the center always visible. Is this possible? Essentially I have a data set sorted by date. I have reports of an issue prior to a corporate communication going out and then after. I would like to be...

Some videos you may like

This Week's Hot Topics

Top