I think this is rather simple but I just don't have the brain power to
figure it out.
I have two row in a excel spread sheet
data info- sheet 5-rows A and B
in these rows there will be radomly placed numbers that I need to get
to go into a sread sheet.
I tried autofilter and it works if I manually want to do it but I
would liek to set up this so a macro can do it.

Any ideas?