Finding and copying whole rows

[Kamil Cieluch]

Hi. I guess I will get straight to the point. Can someone help me with
the formula for finding the cells of special properties and copy them
all into different sheet? For example:

A1 A2 A3 A4 A5 A6
1 10 20 30 40 101
2 10 20 30 40 102
3 10 20 30 40 103
1 11 19 30 40 101

I would like to know if there is a formula to find the rows by the
sums of 5 numbers in columns A1:A5, and copy them. So, If I put 101,
then whole row with the bold numbers will be selected, copied and then
I can paste it in into different sheet. I think its obvious that I
want to try it with all the sums that will be in the worksheet, so its
not just for one cell specific cell and number.

Thanks

 

[Gord Dibben]

I think you have rows and columns confused.

A1 A2 A3 A4 A5 A6 is 6 cells in column A

Do you mean Columns A B C D E with =SUM(Ax:Ex) in F

Whatever the case, formula cannot copy to anywhere. They just return values
to the cell in which they are wriiten.

Have a look at Data>Filter>Autofilter.

Filter for 101 in column F.

Copy those results and paste to another sheet.


Gord Dibben MS Excel MVP