cells formula

Hello fellow excel users, I have 5 spreadsheets each with 48 columns. Based on the values entered in 'column B' I would like to copy those particular rows but not all the columns to a separate 'destination' sheet. Also, checking across the rest of the spreadsheets. Please see below to the...

hi guys i have a table below. In example a if i do the simple sort function i get result A, But i need to get to result B can anyone help me with this ? Result A Result B <colgroup><col style="mso-width-source:userset;mso-width-alt:3140;width:69pt"...

Im trying to do something like this "om" is the if formula but in my language Range("f3").Value = "=OM(+'1'!H3=0;"";+'1'!H3)" and for some reason i get the 1004 application or object defined error when i do this the first line of code works but the same error appers on the next line, why...

Good morning to everybody, and sorry in advance for my poor knowledge of Excel. I think my problem is not very hard to solve, I've searched a lot on Google but I can't find some formulas right for me...or maybe I'm not able to apply that formula to my spreadsheet. This is the problem: _ I' ve a...

I am trying to have the value in cell A1 which is dal be the basis to clear the values in cells a5 to a500. The below formula does not work for the loop function; help much appreciated. ------------- Option Explicit Sub test() Dim x As Variant Dim y As Long x = Cells(1, 1).Value MsgBox x y...

I'm trying to change a cell, at the bottom of a column, to a different colour once all the cells above, in that column, have a date in. Ie once all the cells have dates against purchase orders, then the cell would turn green and say Completed. I know you can use conditional formatting for part...

Do you know what is wrong with the following Sub CellFormula() Dim FormulaNo As Integer Dim i As Integer FormulaNo = 10 i = 10 Cells(i, 13).Formula = "=" & (Cells(i, FormulaNo)) & "/" & (Cells(i, 12)) End Sub I'm getting Applicatio-defined or object-defined error Thanks