Creating a new worksheet from existing work sheet by pulling rows if value in cell is +

[oddcarout]

Ok,

I have a worksheet with about 1000 rows of data, and I want to copy an entire row over to a new worksheet but only if the value in column f is a positive integer.

Any ideas?

thank you,

[Pepe Le Mokko]

You'll need VBA for this. I'll move your post
(Also I think this problem was already addressed a few times on the board)

[Pepe Le Mokko]

BTW could you please add your location ( approximate) and your XL version to your profile? This might be helpful for members willing to help.
Thanks

[Marc L]

Any ideas?

Just use a filter then copy or an advanced filter and no need a code if it's not an everyday task …

[nigelog]

This will give you an idea

Please Login or Register  to view this content.