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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|