inserting columns

  1. M

    Referencing Columns based on Header Names in VBA Macros; Excel 2013, Windows 10

    Good day to you. I'm trying to revamp a bit of VBA code based on unknown column locations, known only by their header names. :cool:This first bit of code is working properly as it should: Private Sub STEP4_Separate_Name() ' '''''''''''''''''''''''''''''''''''''''''''''Insert 4 columns to...
  2. R

    Insert a column with out messing up linked data

    Hello All! I am using office 365 and when i insert a column into a data sheet, all the reports that I have linked get miss aligned. Is there a way to insert a column in the middle of an existing worksheet without having to go and update all the linked data reports? Any help is greatly appreciated!
  3. S

    Need help with Formula when I insert a column

    I have an end column that I am trying to sum up from the cells in the earlier columns, and I need the formula to also account for any new columns that I insert into it. I also have an IF statement in there as well. So my current Formula is this: =SUM(IF(C2>0,1,0),IF(F2>0,1,0) that creates 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