Hi,

I am new at this VBA stuff and am having an issue programming this one issue I have.

I have mulitple worksheets (labelled W1, W2, W3, etc.) and I want my program to find all rows with a numeric value in column A (quantity column) and copy the entire row to a different worksheet called 'BOM'. I would like this done for all worksheets (I have from 10 to 20). As an additional feature, It would be nice for it to automatically update the 'BOM' worksheet if changes are made on the other sheets (ie: quantity numeric value changes or deletion/addition of a numeric value.) Thanks for any insight or help.