How to copy only specific cells?

tjgibbs Posts 3 Registration date Thursday November 16, 2017 Status Member Last seen January 10, 2018 - Updated on Nov 29, 2017 at 01:11 AM
I am attempting to create a document that will distill necessary information on a contract and spec sheet without having to do all the meticulous typing. In doing so, I would like to copy only rows of my choosing that contain a value in column B greater than 0, and I would like these cells to be copied into a space about 10 rows deep. How would I do that?

See example:!5538&authkey=!ALtkmG1fy7hvPbk&ithint=file%2cxlsx

Thanks for your help!