Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
how can i auto insert a line between different blocks of data in a single
column? for example, in a year to date export of shipments, i need a total count of shipments for each month based on the outbound shipping numbers (BOL's). so if july 07 had 27 different shipping numbers, i'd like a line to auto insert at the end of the july batch based on the date column and total the number of shipments for the month. thanks in advance for any help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
you need to make a column that shows the month of each row and then do subtotals based on that column Thanks, -- Farhad Hodjat "Outbacker" wrote: how can i auto insert a line between different blocks of data in a single column? for example, in a year to date export of shipments, i need a total count of shipments for each month based on the outbound shipping numbers (BOL's). so if july 07 had 27 different shipping numbers, i'd like a line to auto insert at the end of the july batch based on the date column and total the number of shipments for the month. thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a line | Excel Worksheet Functions | |||
Inserting an Image or Line | Excel Discussion (Misc queries) | |||
Inserting an image or line | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) |