Hello, I have some data in the spreadsheet,...

[Brian_Tanutama_]

Hello,

I have some data in the spreadsheet, this data is come from “filter” formula (so when one coloumn in book A meet the condition, this row will be copied to this book)

the problem is from more than 5 rows in the spreadsheet, it just shown 2 rows?

why this happened?

Thank you.

[Aleksi_Alkio]

Check your key column’s values. You have probably the same key column’s value more than once.

[Brian_Tanutama_]

work like magic. thank you very much for your help

[Aleksi_Alkio]

You’re welcome