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

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