I figured It out,

the macro is coppying and pasting only the first and last fruit of each type
to the tab with that fruit name.

so that means thas each tab will only have max of 2 rows.
if the colum has and 2 type of fruits, grapes and apples 5 rows : apple,
apple , grape, grape, apple. the output will only be 2 tabs with 2 rows.
if you number the apples, as aple 1, 2 and 3. the apple tab would have
apple 1 and apple 3 , skipping aple 2

"Paulo" wrote:

actually

playing a littel with the DB

I cant tell what is really happening, because I have 10 fruit entrys now. 3
of them are grapes. number 1, 2 and 7 . the macro is able to add ut the tabs
correctly. but it just addes up the row 1 and row 7 skipping row 2.

I can't thank you enought Rick