lookup value|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Mohamed,

attached a possible solution: you make a pivot table from your data. In the settings of the Pivot table you fill in that every new MDN starts on another page. You can see this when you print the pivot table sheet.

I think there is also a way to split such a pivot table, but can't remember how. Maybe someone else here on the Forum?

Good luck!

Frans

I think that's not possible with a normal function because of the different amounts for the MDN's. You don't know in advance how many MDN-01 and MDN-02 etc. there are. So you don't know how many rows you need on your second sheet.

Maybe with some VBA or so, but that's for other people here on the Forum and not my ability.

My solution gives you the required display. You only have to make an Excel table of your database and refresh the pivottable. That's not that work I think?

Frans