Automated filter, copy, paste... Recommendations appreciated! [Closed]

Report
Posts
3
Registration date
Thursday November 16, 2017
Status
Member
Last seen
January 10, 2018
-
 Blocked Profile -
Hello,

I am a self-taught rookie 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. Would anybody be able to help me do that? I have attached an example that should explain it more clearly.

See example: https://onedrive.live.com/redir?resid=8F1F473CDCD4818B!5538&authkey=!ALtkmG1fy7hvPbk&ithint=file%2cxlsx

Thanks for your help!

1 reply


OK check this out:
https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

Everythin you just asked for is in that article. You just hace to reverse engineer the examples to fit your "model"!

Let us know if you have any issues with it.
Posts
3
Registration date
Thursday November 16, 2017
Status
Member
Last seen
January 10, 2018

Thanks for the reply!

I guess I will have to study up on VBA because I dont understand much of what that article is talking about.

No chance I can do this without VBA, huh? Haha. Thanks again!
Blocked Profile
You can record macros, read them, and see where variable will go, change the variables, and link all of the command together. That is how I started!