| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to sum columns in all sheets in a workbook
I need to write a macro to sum the same columns (ie.. G:O) in every worksheet
within a workbook. I need to add it to a macro that I already have which splits sheet 1 into other sheets using the information in column A. I have that macro working as well as using an auto fit macro for all sheets, but now I need to total the columns in each sheet that was created. I have a macro that works when it is one sheet but I don't know how to do it for all sheets. Also, the columns in each sheet will end in different rows. -- Thank you, Jodie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In need to link Columns between sheets of a workbook? | Excel Discussion (Misc queries) | |||
| Resize columns for all sheets in a workbook | Excel Programming | |||
| macro to compile columns on multiple sheets | Excel Discussion (Misc queries) | |||
| Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming | |||
| comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
