Hey everybody,

I have two sheets one of them with names in b31:b40 (sheetname:"ziel")
and anotherone with lots of data (sheet quelle).
I want the macro to take the value in b31 and look for alike values (values that contain the b31) in the sheet "quelle".

The quelle sheet is autofiltered and the macro is supposed to take the subtotal after filtering all alike values.
Unfortunally the way I try it doesn´t work.
Anyone an idea please?

Thanky you very much!

regards el_don








Please Login or Register  to view this content.