putting

Hi, Can someone tell me why my If statement is not working...

I have the following line of code Worksheets("Sheet1").Cells(RowNo, ColNo).Copy Worksheets("Sheet2").Range("B" & (DstRowOffset + ColNo + 1)) I would like to paste the cell with "pasted cell", CHR(34)&Value&CHR(34)&CHR(44) Any one know how to do this ?

Hi Folks, Just a quickie (I think/hope)... :roll: I had a formula in a spreadsheet cell: =TRUNC(MAX(((MAX(E5-5,(E8-4)))/10),1)) that I needed to move into code, i.e.: Sheet1.Range("J18") = TRUNC(Max(((Max(E5 - 5, (E8 - 4))) / 10), 1)) The VBE/Compiler doesn't like it in this form. After...

I have this formula that I copy down the page but the issue im having is where im copying the data to if either cell in original cells are blank it putting a 0 in and I need that blank =INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28)) lets say BA3 has something in it...

Hi Can anyone help me think of a formula where if i have multiple dates in one column, the column next to it will differentiate it by putting - 2, -3,-4 for ex see below col A Col B <colgroup><col><col></colgroup><tbody> 20060704 20060704 20060704 20060704-2 20051222...

goodday guys, im looking for a macro which will get the data from website html file. But this html file is different every time. Is there some way i can set a macro to get the data from website when only putting the page which needs to be inmported on for instance putting the hmtl in cell B1...

Good Morning, In cell A2 i am putting 10/01/19 12:00 in cell G2 i am putting 12/01/19 16:00. I am wanting to work out the difference between these 2 times. But the catch is i dont want the hours counting between 16:00 and 08:00 and also weekends/bank holidays if possible. At the minute i...

Please help i have to combine these 2 formulas each has the criteria I need just stuck on putting them together. =SUM(COUNTIFS($P:$P,"<> / /",$D:$D,">="&$B9,$D:$D,"<="&$C9,$A:$A,$D$5)) And =AND($T:$T>=EDATE($P:$P,-2),$T:$T<=EDATE($P:$P,2)) Any help most appreciated ?

Dim sht As Worksheet Set sht = ActiveSheet Sheets("sheet2").Shapes("ImgG").Copy Sheets("NPSS_quote_sheet").Paste _ Destination:=Worksheets("NPSS_quote_sheet").Range("sht.Cells.SpecialCells(xlCellTypeLastCell).Row"+4) I have a worksheet, NPSS_quote_sheet that I need to paste a...

lets say i have two column in sheet 1 A is Names B is code of them in sheet 2 i have just names how can do below 1- check the names in sheet 1 with names in sheet 2 2- putting the codes of names in sheet 2 thanks

Hey All My version of Excel 2010 has started automatically putting a single apostrophe at the start of every cell I type in except numbers and I can't work out how to stop it :-/ I've only noticed because it's started effecting code in one of my books where a cell gets a value tested and it...

I don't understand how to implement this formula: IFERROR(INDEX($C$23:$C$265, MATCH(0, COUNTIF(N$23:$N23, $C$23:$C$265), 0),1),"") I need to remove the duplicates in list C23:C265 and place the new entries in N23:N52 I've tried putting it in cell n23 and copying down but it doesn't produce...

I would like to subtract B5 - B4 putting result in D5, such as B5=322 and B4= 442 than 322 - 442 = D5.

This is going to be quick and easy for you all. On my Userform I have sequential numbers moving over to my spreadsheet But I want the number in A4 to start at 1000. I have tried putting 1000 in every spot I could to get it to work but to no avail. If I put 1000 in Cell A4 then it works and goes...

Here is my current formula {max(if(a3:a1000=B3,i3:i1000,””))}. So this is returning my max value when there is one or multiple but it’s putting a 0 when there isn’t anything.

Hello, Im currently working on a spreadsheet for my work to show what parts we need each week to finish our project, i have been requested to make out all the parts by sundays, and was wondering if putting the delivery date in one cell, if there was a formula that would see say "25-Jan" and put...

Dear Experts. I want any condition/formula which can stop putting same word in a particular column. Apple Banana Orange Apple (Stop) word already exist

A google doesn't bring anything back and I can't see any options about it so I suspect not... Is there a way to stop it putting 'Column Labels' and 'Row Labels' in? I know they're Row and Column labels. Apart from colouring the font the same as the background, can you tell XL to desist pointing...