empty cell

  1. Y

    How to find max value with empty cells & #div/0!

    Hello, I have inlcuded an example chart that I use regularly for work below (assuming it starts in cell A1 - so data range would be B2:AH34). Is there a way to find the max value of this chart, or even the top 5 max values (would be ideal but will settle for just one max figure for now if it's...
  2. S

    Changing Window Within Workbook

    Within a Workbook, I have a window (Sheet2) that needs to be active for entering raw data and a window (Sheet1) that will be up on a monitor, showing live, manipulated data. In order to keep the current line item on the screen I have it run Application.Goto Target.EntireRow on Sheet1, which...
  3. U

    Treeview Parents/Child - How to return the first non blank value located one column to the left of the source cell and n rows upward.

    Hi all, I'll try to be as clear as possible so please do not hesitate to ask for clarification. I'm working with a text file data extracted from CATIA V5 that replicates the tree structure of an assembly with its components and subcomponents. From that text file I arranged the source data in...
  4. T

    Find Next Empty Cell

    Hello, I have the following code: Sub EmptyRow() On Error Resume Next Application.Calculation = xlCalculationManual Application.EnableEvents = False Application.ScreenUpdating = False Dim wbCurrent As Workbook Dim wsCHINO As Worksheet Dim wsSTOCKTON As Worksheet Dim wsFLM As Worksheet...
  5. A

    Loop through empty cells and data move to one cell left

    Hi All, Loop through empty cells and data move to one cell left <tbody> Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date 11/6/2019 Normal 28035 Y NO Date...
  6. K

    Subtract constant in sum function

    Hi All, I have a small problem. I need to sum a range of numbers and subtract a constant. I have used the method: {=SUM(B4:BUU4-0.5)}, which gives me a #VALUE error. The problem occurs since there is empty cells in this range. I have also tried with a {=SUM.IF(B4:BUU4,">0",B4:BUU4-0,5)}, but...
  7. N

    VBA Extract and sum numeric values from bracket

    Hello, I had a code for this but I can find it anymore. Basically, I have a sheet with a column of alphanumeric values. At the end of each string I have a decimal value between brackets, but also some text. I would like to extract the numeric value only, sum all the extracted values with the...
  8. J

    Blank cells as result of formula with ""

    Hello guys, I'm making a macro that finds the last empty cell and paste from there, the problem I'm having is that Excel won't consider an empty cell when copying a cell which formula's result is "" and pasting values, hence, the macro leaves as many empty cells as where copied from blank cells...
  9. M

    VBA - copy the first row that has empty cell

    Hi, I want to make a macro to copy the first rows to the last rows that is empty in column A (below: A4 to E6) from workbook called "XXX" to my current workbook called "ZZZ". <tbody> A B C D E 1 2252 1 7 13 AAA 2 2253 2 8 14 BBB 3 2254 3 9 15 CCC 4 4 10 16 DDD 5 5 11 17 EEE 6...
  10. M

    VBA - copy and paste onto the next empty cell

    Hi All. I was wondering how to paste some selected data that I copied from Sheet1 onto Sheet2 in the same workbook on the next cell that is blank. So far, I have the following codes: Sub Step4() Sheets("Sheet1").Select Range("B1:L34").Select Selection.Copy...
  11. K

    Find first cell that displays nothing

    I have formulas in from cells B3 down through B1000 of a spreadsheet that will display "" (nothing) if they evaluate to false. There may be an instance where a particular cell within this column evaluates to false and I am trying to find and select the first cell that displays nothing using the...
  12. P

    INDEX result with date criteria & skip empty cell

    <tbody> A B C D E F G 1 DATE FROM TO PRICE 2 01-03-18 A Z 18,900 3 10-03-18 A Z 18,500 DATE : 4 29-03-18 B Z 18,900 FROM : 5 11-04-18 A Z TO : 6 18-04-18 A Z 19,500 RESULT : 7 18-04-18 B Z 19,800 8 26-04-18 A Z 9 27-04-18 A Y 10...
  13. J

    VBA Excel If cell value is empty ERROR

    I had a good working VBA program to copy in order and sum things up. I wanted to make my program even better after the client worked with it a bit so I changed some small stuff and tryed to run the macro. It came back with an error on the next line For Each cell In newven.Range ("G:G") If...
  14. S

    Find empty cells in multiple range of cells

    HI, I am trying to build a checklist wherein user inputs a string in column A within the following ranges A6:A8, A10:A14, A16:A18 and A20:A23. I can also name these ranges as Sec1, Sec2, Sec3, and Sec4 for easy reference in the code. I am trying to get a vba code that would check if all the...
  15. D

    Quick Question

    Hello everyone. I have a short question i really really need answering. A1 = 350 euro B1 = 500 euro C1 = B1-A1 (ok i do a simple SUM) but in case 1 variable "Say.... B5 isnt in yet so the box is blank..." How do i B2 = 450 euro C2 = B2-A1...
  16. K

    Macro that identifies non blank values on column and create new column on another tab with no empty values

    Hello, I'm new to VBA and I would like some help. I have a huge table and I'm interested in values on columns A, H and I. What I would like to do is to identify for each row if the cells on columns H and I are empty or not. If either cells on column H or cells on column I on a specific row...
  17. R

    Skipping Empty Cells with a Formula

    I have a worksheet that goes over a 24hr period. Each hour a user enters their hourly count. One of my lines has a running daily count. I have =IF(K1677="","",K1677-K1676) as a formula. It takes the amount enters in the previous hour and subtracts it from the current hour to give the actual...
  18. D

    Conditional Formatting: Based on comparison of cells between worksheets, if cell is blank

    Hi all @ Mr Exel! I have a conditional formatting problem I can't quite get my head around and I'm hoping someone can help me out. First let me just say that I have been unable to find anything in the existing forum topics that resolves this, but I have been able to make some progress using...
  19. E

    Fill Blank Cells To Left

    Hi I want to know if there is a way to to fill empty cells with value left. i have this example: e d c b a 1 Y X 2 Y X I want to get this: e d c b a 1 Y Y Y X X 2 Y X X
  20. C

    Delete row when linked cell values are empty

    I want my macro to loop through a series of files and, if all the cells B10:F10 in Sheet2 are empty, then delete row 10. I think my problem is that the value in each cell is linked from Sheet1 and the zero for an empty field is hidden (e.g. ='Sheet1'!B22 & ""); I have tried to delete for both...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top