Transfering rows to one sheet from multiple sheets under condition.

[Alvonwin]

Hi!

I'm not that good at doing macros but, if you are, that should be a child game!

All I want is to have the datas from my inventory sheets to be copied into the corresponding sheets "To Order" or "In Stock"
depending on the values enter in the other sheets,.

If the numbers in column To Order is more than 0, item should automatically show in "To Order" sheet.
If the numbers in column In Stock is more than 0, item should automatically show in "In Stock" sheet.

Look at the pics you should figure this up really quickly.

Thanks!