Copying dates from one to anther sheet

[ceki2303]

Hi guys, hope you all well

Need your help for this one.

So im trying to write down formula to copy all datas needed from Sheet1, to Sheet2 only if i put one date into required filed.

So as you can see in the pictures if i enter date into filed F7 it needs to copy Name, Club, And Visit into Sheet2


Thank you for your help


http://i284.photobucket.com/albums/ll11/ikce/help 1.jpg

http://i284.photobucket.com/albums/ll11/ikce/help 2.jpg

 

[Stridhan]

In sheet2 you have visit 2 but the date for visit 1, is that correct?

 

[ceki2303]

Hi Stridhan,

Sheet1 i have Visit 1 and Visit 2, but Visit 2 is only important. Visit 2 will be in Sheet2.

Thank You for Your Help

 

[Stridhan]

Try this in A2 in sheet2 and drag to right and down.
I dunno how large the range is on sheet1 so I have the used row 100 in my example.

=IFERROR(INDEX(Sheet1!$B$2:$F$100,SMALL(IF(Sheet1!$F$2:$F$100<>"",ROW(Sheet1!$F$2:$F$100)-ROW($F$2)+1),ROWS($A$2:A2)),MATCH(A$1,Sheet1!$B$1:$F$1,0)),"")

 

[ceki2303]

thx buddy, but it doesnt work

 

[Stridhan]

I guess i missed NO on sheet2

 

[Stridhan]

=IFERROR(INDEX(Sheet1!$A$2:$F$100,SMALL(IF(Sheet1!$F$2:$F$100<>"",ROW(Sheet1!$F$2:$F$100)-ROW($F$2)+1),ROWS($A$2:A2)),MATCH(A$1,Sheet1!$A$1:$F$1,0)),"")

enter with ctrl+shift+enter, not just enter