Looking to copy entire row if a cell value is greater than zero

any ideas??


attached a sheet
If column D is greater than 0 then I want to copy the entire row to Sheet 2

basically, I only want to see rows with a quantity on Sheet 2

this is an ongoing, feed so I can't use Filter

THANKS!!!

Hello Dadof2,

This code may help:-

Please Login or Register  to view this content.

Here is a sample work book:-

Let us know if it does the job for you.

Cheerio,
vcoolio.

Hi.

this is an ongoing, feed so I can't use Filter

Can you explain that.. it would be much fast to:

1. Autofilter your range by column D for values >0.

2. Copy the visible rows after autofilter to the other sheet. No loop needed..

Why can't you use autofilter?

Thanks for the help!

Okay, I ran it and have a question

The first time it runs it works, but if I run it again (say later in the day) I get the old info and and new bonds that meet the criteria. How do I get it to clear the Sheet2 and give me a fresh look every time??

Thanks
Mark

Originally Posted by apo

Hi.



Can you explain that.. it would be much fast to:

1. Autofilter your range by column D for values >0.

2. Copy the visible rows after autofilter to the other sheet. No loop needed..

Why can't you use autofilter?

Doing this, do I have to manually click the auto-filter each time? Currently, I pull in the info using an API and would like this to automatically look for the bonds with greater than zero quantity and run. I am trying to do this with as little steps as possible. I will set this up and have some "older" users use it so it needs to be as dummy proof as possible. does that make sense???

THX
Mark

Hi..

Try this..

Note: You will need to add column headers like i have in the attached Workbook..

Please Login or Register  to view this content.