HELLO
CAN U HELP ME BY ( VBA) TO RETURN THE LAST INFO ( PRICE - DIS1-DIS2) BEFORE THE ROW I SELECT BUT WITH MULTI CRITERIA AND MAX DATE , MEANING WHEN I SELECT CRITERIA 2 THE LAST INFO APERAR IN CELL AL2420 WHICH CONTAIN THREE DATA (PRICE-DIS1-DIS2) BUT JUST DATA BEFOR AL2420 .
THANK U
CAN U HELP ME BY ( VBA) TO RETURN THE LAST INFO ( PRICE - DIS1-DIS2) BEFORE THE ROW I SELECT BUT WITH MULTI CRITERIA AND MAX DATE , MEANING WHEN I SELECT CRITERIA 2 THE LAST INFO APERAR IN CELL AL2420 WHICH CONTAIN THREE DATA (PRICE-DIS1-DIS2) BUT JUST DATA BEFOR AL2420 .
THANK U