How many different numbers will need to be moved to the spread sheet?
Are the numbers in both columns A and B of the sheet where they are randomly
located?
Where do you want them put on the spread sheet? Down a column? Across a row?
Does the number of items in Columns A and B of the sheet with the radomly
located numbers vary in length or is it a fixed range such as A2:B100? Are
the numbers formatted as numbers or text? How do you want them formatted in
the spread sheet?

" wrote:

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?