header blanks cells

  1. A

    Adding conditional column title - VBA

    Hi, I'm new to VBA and would greatly appreciate your help with this query I have a sheet that looks like this I would like to add column titles in the highlighted cells based on the first left column that is not blank. For e.g. D1 will have the title -> C2+"_1" a.k.a "Column2_1" and cell E1...
    • ana_c
    • Thread
    • #conditionalformat #vba header blanks cells insertheader macro macrocolumntitle
    • Replies: 15
    • Forum: Excel Questions
  2. M

    Capture Header Name in Cell Rows based on last non-null column.

    Not sure how to ask this question, but hopefully with the picture below it will be clear. I was able to add my first CUSTOM COLUMN(Col U) in PowerQuery using the below formula and it worked well to retrieve the last Non-Null field in my list of dates. CUSTOM COLUMN =...
  3. 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...
    • lwebbie
    • Thread
    • blank cell header blanks cells paste paste cell vba & macros
    • Replies: 0
    • Forum: Excel Questions
  4. S

    Match list name of header and find blanks cell and take all blanks column header name in remarks (vb code)

    hi, i have list of header name,were i need to Match list name of header and find blanks cell and take all blanks column header name in remarks and need to put comma after each header name and remove last comma . if find single blank cell add ( is Not Available ),if more add ( are Not...

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