dual

  1. J

    New Window with VBA (Dual Monitor)?

    Hi, Is it possible with VBA to open a new window (specific worksheet) maximized on to the 2nd monitor with no gridlines?
  2. R

    ADO Recordset empty on Office 2016 64bit (excel)

    Hi All, Thanks in Advance I am having issues with a script that I am trying to run, when I run a simple query it prints out the result but when I query any table on the DB it does show anything and prompts me an error. I ran both queries on PL/SQL and got the correct results, any ideas why it...
  3. S

    Use wildcard in IF/OR formula

    Hi, I am trying to find out if it is possible to use wildcards in a formula. In the formula below you can see the items in the "OR" statement all start with "FAS-5". Any help is appreciated. Thanks =IF(OR($BF24="FAS-5 SL - HIGH",$BF24="FAS-5 SL WHITE",$BF24="FAS-5 SL ANOD",$BF24="FAS-5 DUAL...
  4. S

    Output certain text in Bold

    This formula shows the "ABOVE DUAL SHADES" text in a line on my worksheets. Is there a way to output that text in Bold. Thanks =IF(FINALORDER!$B25="ABOVE DUAL SHADES","ABOVE DUAL SHADES",IF(FINALORDER!$HD25="","",(FINALORDER!$HD25)&" - "&(FINALORDER!$D25)))
  5. G

    Counting reason loop

    Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...
  6. G

    Scan through loop

    Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...
  7. S

    VBA to sort data from multiple worksheets and compile into a worksheet (all same workbook)

    Hi, I need help to create a macro using vba to sort out data. There are many worksheets containing date&time values and for each worksheet, I have to sort out the data. Those with identical date&time values are classified as dual and those with only one date&time value are classified as single...
  8. A

    UserForm Dual Screen BOTH screens

    From searching, I see there's a plethora of data on UserForms in dual screen environments, such as centering on the window, displaying on the proper screen, etc. But here's my question: Can I make a Userform take up BOTH screens? I want it to be maximized to the fill the entirety of both...
  9. I

    Dual dropdown list, second list is filtered based on selections from first dropdown

    I’m wondering if anyone has a solution for the following without having to resort to VB code, as I’ve been racking my brain for the past week, researching, reading, testing, etc. Here’s the scenario (example data below). I have two worksheets...
  10. S

    nextval from dual

    I have the following code, but I don't know what it exactly means. It gives me the next 'available' unique upload_id I guess, but why is it called "UPLOAD_SEQ"? I've seen examples where it looked exactly like my code but with another name instead of UPLOAD_SEQ. With objRecordset .Open...
  11. L

    Dual Column Drop Down Where only one Coulmn Populates the Cell

    I've been trying to solve with a 2 column drop down. What I am hoping to do is use two columns to aid the user in selecting the correct entry. So the first column will be a number and the second column would contain what the number means If: Col1 | Col2 001 | Horse 002 | Cow 003 | Dog Both...
  12. A

    Table Interpolation Any Ideas? (tried over 20 formulas with no sucess)

    I have attempted several formulas with no sucess. The goal is enter ALT and TAS data into the E,F <DUAL INPUT Reference>. (See line 1. below) IF(E1s value <= $A$1:$A$15 values = TRUE, THEN F1 = E1 AND F1s VALUE MATCHES <= $B$4:$B6 VALUES THEN RETURN LBS = 3.5 Any Ideas? <Look Up Info>...

Some videos you may like

This Week's Hot Topics

Top