A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Split report for email



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 08:56 AM posted to microsoft.public.excel.misc
BabyMc
external usenet poster
 
Posts: 28
Default Split report for email

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?
  #2  
Old June 1st, 2010, 01:45 PM posted to microsoft.public.excel.misc
Gary Keramidas[_4_]
external usenet poster
 
Posts: 66
Default Split report for email

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?


  #3  
Old June 1st, 2010, 02:59 PM posted to microsoft.public.excel.misc
BabyMc
external usenet poster
 
Posts: 28
Default Split report for email

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" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?


.

  #4  
Old June 1st, 2010, 03:10 PM posted to microsoft.public.excel.misc
Gary Keramidas[_4_]
external usenet poster
 
Posts: 66
Default Split report for email

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
news
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" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?


.


  #5  
Old June 3rd, 2010, 08:07 AM posted to microsoft.public.excel.misc
BabyMc
external usenet poster
 
Posts: 28
Default Split report for email

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

"Gary Keramidas" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
news
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" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?

.


.

  #6  
Old June 6th, 2010, 11:33 AM posted to microsoft.public.excel.misc
Ron de Bruin
external usenet poster
 
Posts: 2,861
Default Split report for email

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"BabyMc" wrote in message ...
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

"Gary Keramidas" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
news
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" wrote:

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

--


Gary Keramidas
Excel 2003


"BabyMc" wrote in message
...
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?

.


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.