How to copy only specific cells?

Closed
Report
Posts
3
Registration date
Thursday November 16, 2017
Status
Member
Last seen
January 10, 2018
-
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: https://onedrive.live.com/redir?resid=8F1F473CDCD4818B!5538&authkey=!ALtkmG1fy7hvPbk&ithint=file%2cxlsx

Thanks for your help!