check cells

I have 3 sheets in excel, Sheet1, Shee2 and Base price In sheet1 I have values in Column A and Column B, Column A is the Product Code and Column B is the values, In column A there are multiple product codes and multiple values are assigned to it. In Sheet 2 also I have values in Column A...

Hi all, I'm trying to figure out a way to insert 4 rows, based on the value cells in a specific 1-column range. For example, for all cells in column C which equal "I need help", insert 4 rows below. Any help would be much appreciated. Thanks!!! Tony

Hello, :confused: I would check a cell with 2 text rows: - each row length must be max 25 digits long - I need a warning or highlight or cell fill in case one row exceed the max length I have set the data validation to check max length, non considering the row Could someone help me? Thanks...

I have a range of cells 10 columns wide by 16 rows tall... it is assigned the range name of: "USER_CHANNELS" The cells in this range are validated against a range called: "VAL_CHAN_NAME" If the user is typing in data... and they get something wrong... it stops them and forces them to...

Hello, I'm working off an excel file used to track overall and individual performance scores on jobs (for a moving company). Right now, everything is entered/copied into the multiple sheets manually, which is unnecessary, but I do not know anything about macros. The Master sheet will look...

Hey Mr.Excel I'm working on a macro that controlls worksheet. I want my macro to check for each cell if the cell.value is empty in the range from ("F4:F20") and if that is true then check the if the range from U4:AD4 dont have the value = "LB0.1" Sub populateB()Dim rng1 As Range Dim rng2 As...

I want to check if cells C1, D1 and E1 contain the same name. For example if the cells all contain the 'Joe Bloggs' (or whatever the name variable happens to be) then cell F1 should say "Yes", else "No". Anyone out there who can help? Much appreciated!

In a sheet a user enters data in a range, say A1 to F5. In column A the user selects an item from a named list (via Data\Validation\List) with text values. Then, in columns B to F the user enters numbers. In any row he may enters 1,2,3,4,5 numbers or none. When he finishes he clicks a button...