entire

Hi, I have a two dimensional array. The code checks a row element (column 9). If it contains "Include" then I want the entire array row on one worksheet. If it doesn't contain include then the entire row is placed on another worksheet. It then goes through each row in the array checking...

Hello, I need a way yo delete ALL empty rows in an entire workbook with 8 sheets. I found a few here and they do not seem to work for more than one sheet. Any help would be great! Thanks in advance. Tino

Cell B2 has a numeric value= 5 Cell A2 has text with 12 characters Looking to a way to format the font for characters in 6,7,8,9,10,11,12 in cell A2 to red I can only find a way to conditionally formatting for the entire cell

Hello, is there a method to configuring either conditional formatting or a macro in order to highlight an entire row based on a specified word list? This would be ran on the entire workbook "Contains many pages" -If any cell contains specific word 'TEST' change row color to green -If any cell...

Dear MrExcel, In sheets "Data" I want to copy entire row only if cell value in column F, contents these string arrays, regardless the words in Upper case, Proper case or Lower case). - Cement, it could be Type 5 cement, Cements, etc - Spun - Concrete Copying entire rows into sheets...

Hi, I think i have bite of more than I can chew.. looking for some help please? Ideally i was trying to write VBA to check sheet "CFRA" in column G for the word "lighting" IF true move entire row that contains lighting to "lights"sheet. With no luck I used a formula to deter if "lighting" is...

Hi. This is such a simple question that I just can't find an answer for that works. Very simply, when a certain cell is the row is filled in, the next cell populated with the Now() function. What I'm trying to do is just then select the active row from the cell that's been filled in with the...

I have an issue, where a column could have an "X" or any number from "2,3,4,5" in the cell. I need to prevent them from putting an X or anything else in the same column,so two x's would not be good, or two 2's, or even an X and a 2. That would be F18:F34 but the entire sheet is actually...

Hi all, I am trying to auto-fill cell color based on whether the value in column A is odd or even. Odd values would make the entire row (A-O) have no fill, and even values would make the entire row (A-O) have grey fill. Can anyone provide any guidance? Much appreciated. /M

Hi i have alot of delete row codes if cell is empty or even if certain columns have certain names. What i need help on now is Delete entire row except for these numbers in Column D 74,70,113,13,69,115 Any help thanks

I'm trying to create a simple table to be referenced by an IF function. I want to create a single column table of hotel names (i.e. Marriott, Doubletree, etc) and then write an excel formula that says IF(cell reference=a name in the table,"HOTEL",""). In other words, I would like my logical...

Hi, May I know how to write a code to delete the entire row when there is "{" only in column A? <tbody> Column A Column B Row 1 { XX Row 2 {AB} XX Row 3 { XX Row 4 {CD} XX </tbody> From the sample table above, i would like to delete row 1 and 3. I would be so grateful for your help.

Hi all, I am looking to find the text "Final" in column B and insert 5 entire rows above it. Thanks for any help Andy

Can someone show me how to delete an entire row if a Cell.Offset value is equal to a specific value? I have this so far but don't know what else I need to specify the row number; If cell.Offset(0, 10).Value = "Archived" Then

Hi Experts, Currently I faced a problem with my codes, but let me explain what I am trying to achieve here. So I have a worksheet that have many columns and headers, I would like to update the entire column(s) where the header name contains "iot". So the entire column already has values in...

Morning all. I ideally need to take a specific sheet from a specific document and copy it's entire contents, formatting, filters etc into a new xls such that when i open the new xls it will get all the data once more from the original sheet. I know that you could simply set the new xls to copy...

Hello Board! I have been conditionally formatting my spreadsheet twice a day (I download new data every 4 hours) to do the same thing, but I think it would save me a lot of time to have code that does this. The amount of rows varies, but the columns are static (always A-Q) How can you...

Dear people, Does anyone know a VBA solution to check whether a certain string exists in a whole workbook? (true or false would be enough for me) It should not match entire cell content, because sometimes there is a space in front or behind the string that I am looking for. Best regards, Bas

I would like to insure that when ever a workbook is opened it would automatically: Sort all the entire workbook small to large in Colum a, retaining the headers? Thanks -Eds

How to create a vb script in excel wherein i can type a word and/or numbers and it will search all the cells in excel files in the entire shared drive that contains the word/numbers and returns the filename hyperlink on a different sheet? Preferably wildcard search. Thank you.