@ Dear All,
I attach herewith the sample data, which contains various expiry dates. Data is entered in one worksheet and output is required as per the 2nd worksheet. The dates are updated daily /periodically in the worksheet "All data". However, this has to be done in the worksheet "Monthwise" also. The total number of data will be around 200.
The requirement is that, in the worksheet "All data", the data to be extracted in such a way that date and month of each year to be sorted chronologically whenever the dates are updated in the worksheet "All Data"
SANTHOSH
I attach herewith the sample data, which contains various expiry dates. Data is entered in one worksheet and output is required as per the 2nd worksheet. The dates are updated daily /periodically in the worksheet "All data". However, this has to be done in the worksheet "Monthwise" also. The total number of data will be around 200.
The requirement is that, in the worksheet "All data", the data to be extracted in such a way that date and month of each year to be sorted chronologically whenever the dates are updated in the worksheet "All Data"
SANTHOSH