1. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  2. R

    IFBLANK Formula Issue

    I am trying to troubleshoot the following formula =IF(ISBLANK($J4), SUM($K4+30), SUM($J4+30)) where J4 & K4 are date fields. When a date is is not entered in either J4 or K4, this formula displays dates based on the year 1900. How do I fix this to show a blank cell? Thank you in advance. Roy
  3. D

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

    I have this code which filters for "RET" and then goes to next active cell. But in case "RET" is not found in the list, the next active cell will be blank and I want it to do nothing and continue on another part of the code and if it is not blank I want it to replace "RET" with 0...
  4. S

    Help with IFBlank

    Hi, I'm new to this forum and signed up in the hope someone could help me with something I've been trying to figure out for hours without success, including going through the forum here, searching for IFBlank - maybe that's what I don't even need. My data set looks like below with Q1_round1...
  5. E

    Match/Index IFBLANK Conditional Formatting

    Hello Everyone, I searched everywhere and I can't seem to find the answer to my problem and to be honest i don't know if this is even possible. I run a huge family "NFL Pick the Winners" spread in Excel, about 18 of us. I was hoping I can use conditional formatting to change the color of...
  6. M

    If Cell H is blank then return value

    I am trying to get a formula so that if cell H is blank then return the information from cell B. For Example H2 is blank I would like Credit One to be the returned value in Cell B35. I was thinking a count if formula but I am having trouble getting it to pull the correct data.
  7. O


    Hi, I have a simple spreadsheet where I am copying over data from another sheet called 'Master Tracker' in the workbook, so each cell is just a basic ='Master Tracker'!A5 etc. However where some of the cells are blank, I want the cells on my other sheet to also appear blank instead of a zero...
  8. B

    VBA for Combining worksheets but only those rows where cell B! is not blank

    Hi, I am using the following VBA script to combine my worksheets but am having an issue b/c there are formulas in each worksheet running the entire column (columns A and D). I want to combine only the rows where the B column is not blank. Any help in modifying the macro would be much...
  9. L

    Running total calculation from blank celled records

    I'm trying to create a formula out of this: If an item has not been sold then the sold column will be blank. If it is blank then I want to take the figure out of the price paid cell and put the total of all unsold items into one cell to generate a running total of stock. I can do this with...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back