Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have a workbook with seven columns of data and which
may have varying rows of data depending on the month's data being captured. A B C D E F G 1 xx 3 2 qq 4 3 dd 2 4 ww 5 5 ee 8 .. .. .. We are trying to include in our macro a routine that will go to the first blank row below the data and enter the word "Totals" in column A. Then we want to enter the sum of each column (B through G) under each column on the same blank row as the word "Totals." In the above example we would enter "Totals" on row 6 in column A and then 5 would be entered on row 6, column B. 12 would be in row, column C. etc. We got this far with the macro but couldn't figure out how to get the sums entered. Range("A1").Select Nmrows = Range("A1").End(xlDown).Row Cells(Nmrows + 1, 1) = "Totals" TIA for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to add Multiple columns | Excel Discussion (Misc queries) | |||
I need a macro to transpose multiple columns A1-Z1, A2-X2 etc | Excel Discussion (Misc queries) | |||
macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
Macro to align and compare multiple rows and columns | New Users to Excel | |||
macro that loops to multiple columns | Excel Programming |