Insert new blank columns using VBA after every nth column and then copy the formula to these New Columns

M

mikelee

New Member
Joined
Jun 7, 2022
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
Hi ,

I would like to add a few new Columns based on a Cell value (,e.g. Cell B2) to 4 Excel worksheets using VBA after every nth column and then copy the formula in the last columns and paste the formulas to the new blank columns .

E.g. insert 7 new columns from columns I and then copy formulas in Column H and paste formulas in column H to the new inserted columns. Would appreciate any help and guidance you can provide!

Thanks a lot!

Mike


Insert Columns and Formulas.PNG
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

T
  • Question
VBA Code - Copy last column & Insert Copied
Replies
0
Views
62
TheSetBack
T
N
  • Solved
Insert new dates with dynamic formula to include new range
Replies
5
Views
102
Peter_SSs
Peter_SSs
P
  • Question
Automating copying of columns within same sheet in excel using VBA.
Replies
1
Views
139
MountainFog
M
G
  • Solved
Flashfill formula from variable column
Replies
8
Views
50
Alex Blakenburg
A
C
  • Question
Inserting rows when value's are input into cells
Replies
0
Views
568
cdude911
C

Forum statistics

Threads
1,214,985
Messages
6,122,606
Members
449,089
Latest member
Motoracer88

Share this page

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