Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert and sum in empty cell
Hi,
I need help in writing the macro to do the following: After sorting by column R, I need to insert a line between the groups, and then sum the total of column M for both groups (see below) Column M Column R 14.50 03COM 14.50 03COM 14.50 03COM 14.50 03COM 58.00 <------------- 14.50 05IT 14.50 05IT 29.00 <-------------- Can you please help me? Thanks! |