Developing invoices with transaction breakdown


L

Louja

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top