C
Calicojack
Hey guys, I am a newbie at VBA, but I am trying to make a macro do th
following:
I have multiple sheets in a workbook, and most of them have columns
numbered from 1 to 150. Most of the time I only need about 10, maybe 2
columns, and each sheet may require a unique quantity of columns.
I would like to have the user input on sheet 1, the number of column
needed for each sheet, then have the macro automatically adjust th
respective sheet.
the majority of the rows also have some counters and other math at th
end, so the new columns have to be placed or deleted within the column
and the end stage math.
I do not know if it woul be easier to add the columns needed from #1, o
delete the nonessential columns through the macro. I am thinking th
latter.
Thanks!
-Dav
following:
I have multiple sheets in a workbook, and most of them have columns
numbered from 1 to 150. Most of the time I only need about 10, maybe 2
columns, and each sheet may require a unique quantity of columns.
I would like to have the user input on sheet 1, the number of column
needed for each sheet, then have the macro automatically adjust th
respective sheet.
the majority of the rows also have some counters and other math at th
end, so the new columns have to be placed or deleted within the column
and the end stage math.
I do not know if it woul be easier to add the columns needed from #1, o
delete the nonessential columns through the macro. I am thinking th
latter.
Thanks!
-Dav