What I am trying to do is a little advanced for me and I need help. I am trying to find all the cells in a list that have a value greater than zero and copy them, then paste them in order onto another sheet. Right now I have a code than only finds a specific value, but not values greater than zero. Here is an attachment that finds only a specific value and only highlights the cell, not copy and paste it.

Thank you


Test File.xlsm