automatically populate a new sheet with values

Hi -

I am in need a vba script that when executed would go through an excel spreadsheet and do the following :
- analyze each row
- within a given row - say if column F and column J has numbers in it - take that data from that row and copy A, B, C and F into another row into the new sheet. Then take that data from that row and copy A, B, C and J into another row into the new sheet. The result would be new two new rows and four columns in a new sheet.
If you can lead me into the right direction that would be great !

Thanks - jerry

ok this is very good - I will play around with it - thank you very much ! jerry

one more question - it looks as if the macro is checking to see if there is a value in column "F" - sheet 1. If not - it stops. Is there a way to check to see if there is only a value in column A, then stop ??

Hi - I have changes the following which seems to be doing the trick :
Changed :
=IF(AND(ISNUMBER(

To :
=IF(OR(ISNUMBER(

The desired result is located here

https://drive.google.com/file/d/0B_G...ew?usp=sharing
- see sheet 'Results'

If a value is in say column J, How do I bring both I and J ? That is, I and J are related so I would like to have I on the row as well as J.
Also - for example - column E is related to column F - so I would like to bring both over.
Again, see the Results sheet for the desired outcome.

Thanks - jerry

hi - thanks again for your help - I greatly appreciate it !
Almost there

I am still stuck on the last part - any thoughts ? jerryr