dual

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

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...

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...

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)))

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...

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...

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...

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...

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...

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...

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...

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>...