Split report for email

[BabyMc]

I have a report that contains a number of columns - and where the report
contains a number of lines for a range of 'cost centres'.
The report has the cost centre title in one column (say B) and then a number
of rows below that containing various data in the columns.
At the moment the cost centre is only identified in the first row of each
cost centre's data.

At a point the data for one cost centre is concluded and the next row
contains the data for the next cost centre - and so on.

How may I 'split' this report - I guess in to a workbook for each cost
centre so that I can send (via email) to individuals?

 

[Gary Keramidas]

you could use an autofilter on the cost center column. ron debruin's site
details how to send emails.

http://www.rondebruin.nl/tips.htm

 

[BabyMc]

Thanks - however I think there are a couple of issues with that: -

Firstly the cost centre is only applied on the first record of data for that
cost centre. I think I could overcome this however, I'm still not sure how I
can do this as I would wish. This may be because I haven't (though I've just
realised) explained myself properly.

So, secondly; as I will be extracting the same type of data each month -
though, obviously, with a different amount of records. I was therefore hoping
to do this using a macro.
From trying this previously (if memory serves) then when I filter and select
the records, the macro records this as a constant in the row selection. Of
course this would be no good when the number of records are different.


Thanks again - and for Ron's site (I've seen that, it's good).

 

[Gary Keramidas]

post an example of the data that you want to filter on and maybe someone
will be able to help.

 

[BabyMc]

A B C D E
F
1 Cost Ctr Sub Description Period Date Amount
2 001001 2090 Travel allowances P12-09 19/05/2010 -6.21
3 2585 Printing & Stat P12-09 25/05/2010 -37.70
4 001003 0116 Pay - Teachers P12-09 19/05/2010 -4000.00
5 2721 Telephone P12-09 19/05/2010 -210.52
6 2724 Mobile Phone Charges P12-09 19/05/2010 -1789.41
7 001004 2724 Mobile Phone Charges P12-09 19/05/2010 -583.07
8 25/05/2010 -130.38

 

[Ron de Bruin]

Hi BabyMc

You can do this to fill in the same cost centre in the other rows
http://www.contextures.com/xlDataEntry02.html

Then you can do this
http://www.rondebruin.nl/mail/folder2/row2.htm

I have a body example also on my site and one if you not use Outlouk