Developing invoices with transaction breakdown
Hi,
I am developing invoices on the first page there will be a summary of how much each customer is invoiced. This is all fed from a calculation sheet which works out how much per transaction we are making. Each customer will have their own tab for their monthly invoice, which will have their customer no as the tab name. There are over 100 customers. However, ideally I need a breakdown per transaction on the second page of the invoices but am not sure how to do this. Off the top of my head I can think of filtering, pivots but not sure the best way to automate as I won't be using the model and will be off on maternity leave. So needs to be pretty straightforwards to use. Thanks and sorry for the waffle. Louisa |
Developing invoices with transaction breakdown
Anyone??
On May 5, 6:59*pm, Louja wrote: Hi, I am developing invoices on the first page there will be a summary of how much each customer is invoiced. This is all fed from a calculation sheet which works out how much per transaction we are making. Each customer will have their own tab for their monthly invoice, which will have their customer no as the tab name. *There are over 100 customers. However, ideally I need a breakdown per transaction on the second page of the invoices but am not sure how to do this. Off the top of my head I can think of filtering, pivots but not sure the best way to automate as I won't be using the model and will be off on maternity leave. *So needs to be pretty straightforwards to use. Thanks and sorry for the waffle. Louisa |
All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com