blankcell

  1. D

    VBA find next blank, display value from another cell in the same row, input value in blank

    Hello all, I have searched everywhere for this topic, but could not find anything and I am starting to think it is impossible. Basically, I want that the code finds the next blank in column F. Upon that, a msgbox should pop up with the text value of column C of the same row that the code found...
  2. J

    Add data with blank cells to new table + Data validation without blanks

    Hi guys! I ran into a problem which I can't seem to solve. I am on Excel for Mac 2019 Problem: 1. Table 1 is new data. This data contains blank cells in between. I want it to add to table 2, without the blanks. Not directly under it but under table 2 [cell E26] 2. The new table still have...
  3. Z

    Return non blank cells in a row throughout a table?

    H Hi I have made a macro (using a lot of help from this forum) to produce a table made up of rows with postcodes in and then some blank cells before the next postcode my drivers go to. My problem is that the postcodes come out in different columns. So in A1 is a postcode and in D1...

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