Reorganise data to present it

Dear all,

I have a biggie for you. At work I have given a task, that will keep me busy for a whole working week of monotonious work. Thus I very much want to automate it as much as possible. This is the situation.

I have a huge extract of data from our ERP system concerning articles with supplier article numbers, suppliers, product description, quantity and volume sold etc. This data is processed in a Pivot table in order to determine the best selling items concerning quantity and financial turnover. That pivot table is great for analysing, but not for presenting the data.

What happened until now is that someone sat down, looked up the articles numbers and according details and put it manually into Powerpoint to have a presentation respecitvely a nice print of it. This firstly takes ages and secondly even longer since pictures have to be manually looked up and added. So what I want is to avoid the first step of having to copy and paste all the relevant data manually.

Is there any way to fill that data automatically in a nice layout that accounts for one A4 page within Excel and then easily print it out?

I personally have no idea and doubt it, but if you have a starting point for me, I'd absolutely appreciate this.

Thanks a lot,
Regards from hot Hong Kong

sserge

Hi,

And welcome to the forum.

The first thing to consider is using Data Filter Advanced Filter to extract just the records (and fields) you need to a dedicated reporting area. Normally you'd hold subtotals and statistics above the output data so that you don't need to worry about the extract rows being of varying length.