ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   inserting a line between different data (https://www.excelbanter.com/excel-discussion-misc-queries/155663-inserting-line-between-different-data.html)

Outbacker

inserting a line between different data
 
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.


Farhad

inserting a line between different data
 
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.



All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com