straight

Still learning the VBA ropes and I know "select" s/b avoided whenever possible, so I'm posting this. Assuming data is in Range("C136:E139") and I want to copy the data in D136:D139 I used the code Range(Selection,Selection.End(xlDown)).copy which was straight from the macro recorder... Is...

If I have two Quantities and two Unit Prices, is the a formula that will forecast another qty? Qty 100 = $25.00 Qty 500 = 10.50 Is there a formula that would forecast Qty 300 or any other quantity I enter that is between 100 and 500 (Using a straight line)? Thanks

Hi All, I'm currently trying to get an IF function to work where i want the function to basically say, if the number is below -10000 or above 10000 then display "STRAIGHT" in the cell. If not then display the original cell value. I've tried =IF((BO31<'-10000,BO31>10000),"STRAIGHT",BO31) but it...

This is the formula I am trying to use: =COUNTIFS(A5,"PQ",C4:C8,"Actual Straight") It is not working, I am getting a "#VALUE!" error. If I expand A5 into a range of cells (A4:A8), it sort-of works. I say sort-of because I think it really isn't including the range of cells. If "PQ" is in cell...

For the table below, I need formula that will calculate the number of straight Time Hours btw the clock in and clock out times, but I also need it to add an hour for everything break hour that is worked through. I tried a combination of conjunctive IF's with AND/OR with no success. Any help is...

Is there any way to dump the text within a userform textbox straight into the line of code I need it for, without referencing some cell on the spreadsheet?

Hi, I have 3 different lists that can vary in rows dependant on formulas an I am looking to have one list with the contents of the first list, then straight after that, the second list, the straight after the third list Each list has Column A, ID number Column B, Name Column E, ID number...

1. Algebra Practical I A fitness trainer wishes to design a custom field track by setting a number of straight paths and quarter circle turns (in meters). Create an Excel sheet which must contain the following. a) The user can input the value of one straight path length and one quarter circle...

Hi everyone, I want an order straight down for automatically filling in excel. Like this: '=INDEX(Sheet2!$1:$1,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)' '=INDEX(Sheet2!$2:$2,(COLUMNS($A:A)-1)*2+1) &", "& INDEX(Sheet2!$2:$2,COLUMNS($A:A)*2)'...

I am trying to show / hide some lines (basically to show that this area is Not applicable) Screenshot is here: https://prominent.wetransfer.com/downloads/6b62206a80eab4f41513892cf4499e9e20180522162354/f9d0a56871addac95a4eecc83dea5b2c20180522162354/7d9101 Sub CheckBox22_Change() If...

So i'm looking for some code to go to the day of my workbook. Each worksheet is dated 1,2,3,4,5 and so on. But when i open program i would like it to go straight to that day i.e, straight to that worksheet, as i've sometimes forgot to change day!! Regards

Alright, I have done a search and did not find for 0, for #N/A yes, but not 0. Here is the formula, very straight forward: =IFERROR(VLOOKUP(A:A,Physician!A:P,5,FALSE),"") In the results I am getting 0 instead of a "blank". Any suggestions? -T

Hello, This is probably one of those really obvious kind of questions but I have scoured the internet and this forum and I can't find the answer; so I am probably using the wrong search terms... I have built a ton of userforms but I have never used the multipage form before so I thought I...