if loop

[sippe]

Hi,

I neeed some help to make a loop, never don that before. How do I get the
computer to find a certain value in a special area of a woorksheet.

For example find and copy all cells with value 1 in row A and B in sheet 1
and paste it into sheet 2.

Thanks for yor help!

Sippe

 

[Satti Charvak]

Unfortunately looping is not allowed in Excel formulas. You can use looping
only in macros.

Do you want to use macros?

Anyways, why do you require looping for your activity.

why don't you just filter out the date in row a,b for cells which have value
equal to 1, then copy the rows and paste it to sheet 2.

 

[sippe]

Thank for yuor advice. But yes, I'd like to use macros. I think this would be
a quite easy loop to start with to understand the principal of loops and
conditions.

/sippe

"Satti Charvak" skrev: