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

tjgibbs 3 Posts Thursday November 16, 2017Registration date January 10, 2018 Last seen - Jan 9, 2018 at 02:42 PM - Latest reply: ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen
- 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://1drv.ms/x/s!AouB1Nw8Rx-PqyK7ZJhtX8u4bz25

Thanks for your help!

See more 

3 replies

Reply to this topic
ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - Jan 10, 2018 at 05:21 PM
0
Helpful
2
OK check this out:
http://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.
tjgibbs 3 Posts Thursday November 16, 2017Registration date January 10, 2018 Last seen - 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!
ac3mark 9176 Posts Monday June 3, 2013Registration dateModeratorStatus April 20, 2018 Last seen - 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!
Respond to ac3mark