Data fetching based on date

[Sandip Roy]

Dear Friends,

PFA file.

Here in sheet 2, I need the data but when the Date will be Feb then it will snatch data from inv-feb & when march then it will snatch from inv-mar, similarly every month's data will be kept in separate sheet & in sheet 2 data will come based on the date will be mentioned in A1 of sheet 2.

Thanks,
Regards
Sandip

 

[bosco_yip]

Sheet2, F10 copy across and down :

=INDEX(INDIRECT("'inv-"&TEXT($A$1,"mmm")&"'!$C$8:$DV$33"),MATCH($E10,INDIRECT("'inv-"&TEXT($A$1,"mmm")&"'!$B$8:$B$33"),0),MATCH($A$1,INDIRECT("'inv-"&TEXT($A$1,"mmm")&"'!$C$6:$DV$6"),0)+COLUMNS($F$9:F9)-1)

Regards
Bosco

 

[Sandip Roy]

Gr8....!!!