Automated filter, copy, paste... Recommendations appreciated!

Closed
tjgibbs Posts 3 Registration date Thursday November 16, 2017 Status Member Last seen January 10, 2018 - Jan 9, 2018 at 02:42 PM
 Blocked Profile - Jan 11, 2018 at 04:40 PM
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

Blocked Profile
Jan 10, 2018 at 05:21 PM
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.
0
tjgibbs Posts 3 Registration date Thursday November 16, 2017 Status Member Last seen January 10, 2018
Jan 10, 2018 at 06:08 PM
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!
0
Blocked Profile
Jan 11, 2018 at 04:40 PM
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!
0