blank cell

  1. T

    VBA Look for blank cells in columns and highlight the header of the column

    Hi, thank you in advance for you help! Here's what the VBA is trying to do but not successful :) Look for blank cells in columns D and J, if there are blank cells then highlight the header cell in the same column and if no blank then do nothing. This will let me know there are blank cells to...
  2. C

    Dynamic Name Range (Blank Cells) / OFFSET & COUNTA #VALUE! Error

    Good afternoonall, First off, apologies in advance for the long post and maybe long windedexplanation. I have asummary which was created using a combination of SUMPRODUCT, MATCH & ROWfunctions with the good help of Marcelo Branco - This works fine and theresults are as expected. However, I...
  3. T

    Find blank cells in column and put in VLookup formula, but only if there is a value in another cell in a different column

    Hi, thank you in advance for any help on this! Here's what I'm trying to accomplish: On Sheet1, look for blank cells in columns O, Q, Z, AC, and put in a Vlookup formula (referencing sheet2). But only put in the Vlookup formula if there is a value (name) in column B (in the same row and on...
  4. Y

    OFFSET and Blank Spaces.

    Hi, I've only recently started exploring excel functions and i need help with my daily logging chart. Im trying to generate a dynamic chart with the following data using OFFSET and COUNT functions for the recent 7 days. My data is as follows: <colgroup><col width="64" span="15"...
  5. U

    VBA Sort Till Last Blank Cell and Put Blanks on Top

    Hello Gurus, Can you possibly help me on the codes by how to sort below and put those blanks data (Day) on top and maybe put some light yellow highlight for easy reference? Before <tbody> No Code Name Day 1 Day 2 Day 3 Day 4 Day 5 1 001 Jen 50 25 10 5 1 2 002 Sean 3 003 Meg...
  6. G

    VBA delete rows

    I have an Oracle report that is converted to delimited text. I need to delete the entire row if column A is blank. I need the VBA to start on row 30. Does anyone have a VBA code for this? Thank you.
  7. R

    Pivot table show items with no data when group filter applied

    I created a Pivot Table. Table serves two purposes: 1. To list employees (by pay grade) who have completed X, Y, and Z training courses 2. To list employees (by pay grade) who have not completed X, Y, and Z training courses To do this, I merged two Excel worksheets. Worksheet 1 contains a list...
  8. N

    Blank values accepted in a list validated field

    I have a named range without blanks in it. I have configured cells in a column to be validated against this list. If I type in a value that is not in the list and tab out of it, I get the expected error message, but if I leave the cell blank I get no error at all when leaving the cell. I have...
  9. M

    populate column k with most recent populated cell

    I have been racking my brain and google for a few days now and cannot figure this out. Column K is sparsely populated and I cannot figure out a formula to copy down the data from the most recently populated cell in that column whenever the adjacent cell in column L is populated. can anyone...
  10. E

    Highlight Blank Cells Based on a Date in a Different Column

    I have a spreadsheet which has due date in column AB, and a completed date in column AC. If today's date is = to AB and AC is blank, I'd like AC to turn orange. If today's date is +1 day greater than AB and AC is blank, I'd like AC to turn red. If a date is entered in AC which is either equal...
  11. K


    I am interested in using Sumifs function on blank criterion. i.e. =SUMIFS(F10:F66,D10:D66,"MANUAL ADJUSTMENT (SET)"+SUMIFS(F10:F66,D10:D66,"BLANK CELL")). Thank you in advance
  12. E

    VBA BeforeCLose

    Hi all, I have the below code and this is what I want to achieve: IF L1=1 AND B1="" AND C1="" then I want to prevent the file from saving. In all the other scenarios, the file should be saved. I need to also be able to specific Sheet name. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As...
  13. P

    Selecting a range above the blank - macro

    Is there a simple way to select a range from the currently selected cell down to the cell directly above a blank? I'm writing a macro where I've found the first cell in a column that I need, but I haven't figured out how to do a "Shift + Select" down to the cell above the next blank cell. It...
  14. N

    Add blank cells

    Good afternoon, I am trying to create a Macro to add a blank cell in-between line. Every month when we do this there is no way to know how many lines we will have. Manually doing these I do the following: Number the cells next to the date and auto fill all the way down. Copy the numbers. Paste...
  15. A

    Line chart, plot only data, not blank, and label x axis only with plotted data - Help, please

    Greetings all - I have looked high and low and can see that a lot of people have asked about how to keep a line chart from plotting blank cells, but I seem not to be able to nail it down in any effective manner. I have a column that is 25k rows. Each cell has a formula that produces a...
  16. LokimotiveUK

    VBA to copy data from cell above if blank and stop when next data, then repeat

    Hi All! I've been going through tutorials for the past two days to start my journey in VBA, and need some help for an immediate problem. I currently receive a report from an ACCESS database that I don't have access to, and need to get the data filled correctly so that I can then start using...
  17. L

    Paste data into first blank cell after a specific row

    I have a worksheet that has a 7 row header (some rows are blank). I am copying data from 3 different tables and need to paste it into the first blank cell after row 7. One thing to note is I also need to be able to specify the column to paste into as the data in the table isn't in the same...
  18. T

    How to convert this conditional excel formula to VBA code ??

    Hello All, I've got a perfectly working Macro assigned to a button to copy paste the contents from one sheet (Designed like a form) to another sheet (Master database - Locked and Protected). This workbook will be shared with many people to fetch data from each. Now, I want my user not to leave...
  19. D

    VBA: If blank cell do nothing, if not continue with code

    Hello all! This is my first question ever: I am writing a code in which I use autofilter for option "RET" but in some instances that variable is not present. How can I ask VBA to do nothing if the active cell is blank and to continue with the code if the active cell is not blank...
  20. I

    countifs reading the formula rather than the outcome of the formula

    Hi there, I have a countifs function in sheet 1 of a workbook. This countifs function looks up column AH on sheet 2. Column AH is an if function which returns the name of the person who is working the case reference outlined in col A of sheet 1. If there is no reference in column A of sheet...

Some videos you may like

This Week's Hot Topics