UDF to filter every supplier data in a separate sheet

[leprince2007]

Hello everybody,
Could you help me with my question ,please?
* the main sheet in my file is "data" which contains all suppliers data.
* I created a udf to get the data for every supplier in a separate sheet (all columns except column "before").
* But this udf makes the file very very slow. you can notice that when you add or change or delete any data in sheet"Data".
My question:I want to make this udf as fast as possible
Please help me
See the attachement

[rorya]

Do you really need this to be a UDF?

[leprince2007]

Yes I need a udf.I created the udf but it made my file very slow.I need to make it faster

[rorya]

Let me rephrase that: why do you think you need a udf rather than simply a routine(or set of queries) that creates/updates the individual sheets when needed? Also, why do you actually need the individual sheets?

[leprince2007]

I need a udf because my manager need a simpler formula that can understand and edit.I tried a normal formula but it is very big and can difficult to understand.
I put each supplier data in a separate sheet in order to make other calculations on it

[leprince2007]

Can anybody help me,please?
I`am sorry for late response because I was busy.