I am a newbie with little VBA/macro programming experience. I am currently handling an Excel file with multiple spreadsheets where each sheet has a variable column length (i.e. Sheet1 may be 20 rows, Sheet2 may be 40 rows, etc.).
Each worksheet (except the first two) has data in columns I to BD, and some of this data may end with zeros. The first column (A) however, always has a non-zero number (for xlUp functionality). The length of the column obtained from the length of column A may be used for specifying the end-cell for summation.
My task is to calculate the sum of values in columns I to BD of each worksheet except the first two. These are to be reported a in a line below the actual data (i.e. for column I, after the last cell, there is a blank cell succeeded by a cell corresponding to the sum of values I2 to the last cell (corresponding to the last cell in column A).
I am doing this for over 50 worksheets, and therefore would appreciate the convenience of having this in a VBA script/macro. Could anyone please provide any suggestions?
Thanks,
Each worksheet (except the first two) has data in columns I to BD, and some of this data may end with zeros. The first column (A) however, always has a non-zero number (for xlUp functionality). The length of the column obtained from the length of column A may be used for specifying the end-cell for summation.
My task is to calculate the sum of values in columns I to BD of each worksheet except the first two. These are to be reported a in a line below the actual data (i.e. for column I, after the last cell, there is a blank cell succeeded by a cell corresponding to the sum of values I2 to the last cell (corresponding to the last cell in column A).
I am doing this for over 50 worksheets, and therefore would appreciate the convenience of having this in a VBA script/macro. Could anyone please provide any suggestions?
Thanks,