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