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.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"sippe" wrote:

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