blank cells

  1. M

    Reformatting in different sheet

    Hello, I am trying to take a range of cells and reformat them in a different sheet that gets rid of the blank cells. I can't figure out how to do this with a macro since the names of what is in the range will differ and the number of cells with text in them will change as the macro updates.
  2. H

    Copying with blanks

    Hi, I have vba which works very well, it copies down to the last row and will paste on the first empty row, however when it is copying it skips blanks, does anybody know how my code could be modified so that it will copy and paste blanks? I'm copying and pasting from multiple workbooks so that...
  3. V

    Concatenate row with variable columns where some have no data

    Hi, To start off, my question is very similar to the one at this location: http://www.mrexcel.com/forum/excel-questions/553169-concatenate-row-variable-number-columns.html This is the provided solution that I've been trying to use: Sub ConCatFromColumnC() Dim X As Long, LastRow As Long...
  4. E

    Counting bank Cells based on changing criteria

    hi! I am using Excel 2010. BTES worksheet: acct# Oct-13 Nov-13 Dec-13 13245 850 12458 850 45864 12385 1500 MainList - F2= (current month) Based on the current month (which I planned on typing in) on the MainList worksheet I need to count how many blank...
  5. U

    Conditional formatting when cell is empty and another is not

    I need to highlight cells that must be filled in. It is easy to do when you are only looking at the ActiveCell but I need several cell to be highlighted if they are blank and the main Category has been filled in. Example: A1 = Main Category B1 to E1 are sub categories. If there is nothing in...
  6. C

    If... then?

    I have to calculate the days after we receive a notice to when we have to reply. I have two columns column A contains a date when the form was sent out but sometimes I don't have the date the form was sent and I have to go by when the form was filled out (column B). my formula in column C is...
  7. A

    VBA to automatically filter out blank returns and sort two columns for excel 2007

    Hello, I am a manager at a martial arts studio who created the mega attendance sheet from hell...Long story short it accounts for many scenarios that come up in the business. It records attendance for the entire year (which is actually necessary for things like end of year awards). We have...
  8. N

    Need to sort file so that cells that have a certain column blank come first

    I have an Excel file with about 30,000 cells in it. Here's an example of what the file looks like here. And I need it to be sorted like this. To explain further, If someone's name(B) or plan number (A) has blank cells AND additional names under the "Beneficiary Name" column (F), I want these...
  9. H

    Alpha and Numeric Strings have " ' " as their leading character

    Hello all, I hope for this to be my last inquiry on this topic for the immediate future. I have columns A-F which are general formatted cells. These cells have Alpha and Numeric strings. In each of these strings is an '. Does anyone have a non-VBA solution in order for to be rid of the leading...
  10. H

    Formula or Function to Find "blank cells" with " ' "; Replace with true Blank Cells

    Hello all, Although, I was working this into a Macro, I was wondering if anyone had a non-vba solution as well? Basically, I have cells with " ' " due to an extract from our ERP system here at the office. As you can imagine this is quite irritating. My question: Is there a way to identify...
  11. H

    Formula or Function to Find "blank cells" with " ' "; Replace with true Blank Cells

    Hello all, Although, I was working this into a Macro, I was wondering if anyone had a non-vba solution as well? Basically, I have cells with " ' " due to an extract from our ERP system here at the office. As you can imagine this is quite irritating. My question: Is there a way to identify...
  12. A

    Error message if any of 3 cells are blank

    On a spreadsheet I have a "Save" button which saves the sheet in a specific place determined by the contents of 3 cells. C4 = Date, E4 = Venue, I4 = Name These three cells determine the location and name the file will be saved; c:\Venue\Year (from C4)\Month (from C4)\Name (a combination of day...
  13. S

    Deleting Rows Where Cells in Multiple Columns are Blank

    I work with a spreadsheet every week to input values and subtotal them. These values change constantly and instead of going through and manually deleting each row in a 100+ row spreadsheet to be able to import into another program, I'm looking for an quicker way to keep my data in order but...
  14. G

    Calculating number of days between multiple dates with blank cells

    Hi All, I don't even know if this is even possible but here goes... This is based on an accommodation type of business for a mine site. On Sheet1 I have named a few cells being: StartMonth = 01/04/13 EndMonth = 30/04/13 Week1Start = 01/04/13 Week1End = 07/04/13 Week2Start = 08/04/13 Week2End...
  15. B

    Ignore blank cells on formula to join text from different cells

    Hi everyone, I've got the following formula and can't find a way to ignore the blank cells if not data is entered. I'm trying to avoid having double comas when no data is in one of the cells. using formula (=CONCATENATE(A1, ", ",B1, ", ",C1) <tbody> Column 1 Column 2 Column 3 Formula result...
  16. S

    Copying non-blank cells from one worksheet to another

    Here is a sample of the data I am using. Excel 2010ABCD1Myfolder58002Bin18003de400004en500005Random150436Random25044Sheet1 I am importing it from a text file that is pipe delimited. The data represents a folder structure. Items in the same column are on the same level, those that are 1+...
  17. B

    Blank cell which is not blank?

    When accounting software (in my experience) outputs an account in XL format, I find that the spaces are not necessarily spaces. It's easier to explain if I give you an example. Here is a small sample of the output. https://www.dropbox.com/s/egh15zk5kon61nz/Blank%20cell%20problem.xls Columns A...
  18. C

    Message if any cell within a range is blank

    Hi, going crazy with trying to do what should be a simple thing. Would anyone know the code to give a message box if any cell within a range is blank? The code I have tried is below but it doesn't work. Private Sub CommandButton1_Click() If ActiveSheet.Range("A2:AY2").Value = " " Then...
  19. A

    seeking better solution to remove empty text string created by ""

    I've been struggling to remove the empty text string created when I use "" as the false value in formulas. I think I found a way but I wanted to see if anyone has a more elegant solution, and one that would work as a macro. I use the "if" formula to populate many of the cells on my spreadsheet...
  20. B

    Formula to subtotal previous column that dynamically changes so need to find blanks to know which rows to subtotal

    What is the formula that I can use in Column C? I don't want to have to change any cell references as this data changes all the time so it will have to be smart enough to detect blank cells in column B and then place the subtotal in column C. Also, the subtotal in column C is only for a...

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
Back
Top