JimS
07-11-2009, 07:13 AM
I need to insert a column based on the previous column’s header and then add a Sum Formula in that newly inserted column for every row that has data on the sheet.
I need to do this on every sheet whose name begins with the name “Sheet” [ie: Sheet1, Sheet1 (2), Sheet1 (3), etc]. There are other sheets in the workbook but their names will not begin with “Sheet” and therefore do not need to be touched.
The quantity of sheets that begin with the name “Sheet” can vary from 1 to 35.
The number of columns on each sheet can also vary, meaning that the macro would need to scan out until there is no more data.
I have attached an example file.
I need to insert a column after each column that’s heading ends with “MBytes Written/sec” and then I need to sum the previous 2 columns (columns before the newly inserted column) for each row that has data.
The newly inserted columns need to have a header added – a concatenation formula.
=CONCATENATE (LEFT(F1,7)," Total Mbytes") where F1 would change with each newly inserted column to be the previous column
Thanks for any and all ideas…
Jim
I need to do this on every sheet whose name begins with the name “Sheet” [ie: Sheet1, Sheet1 (2), Sheet1 (3), etc]. There are other sheets in the workbook but their names will not begin with “Sheet” and therefore do not need to be touched.
The quantity of sheets that begin with the name “Sheet” can vary from 1 to 35.
The number of columns on each sheet can also vary, meaning that the macro would need to scan out until there is no more data.
I have attached an example file.
I need to insert a column after each column that’s heading ends with “MBytes Written/sec” and then I need to sum the previous 2 columns (columns before the newly inserted column) for each row that has data.
The newly inserted columns need to have a header added – a concatenation formula.
=CONCATENATE (LEFT(F1,7)," Total Mbytes") where F1 would change with each newly inserted column to be the previous column
Thanks for any and all ideas…
Jim