![]() |
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. |
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