Min and Max dates using VBA

[ajoshi76]

Hi

I have 2 worksheets: Sheet 1 and Sheet 2.

Sheet 1 is the Master Db having Application Id, Environment Name, Milestones, Start Date and End Date. Each Application Id can have multiple environment and multiple milestones. Looks like this

Application Id Environment Name Milestones Start Date End Date
App1 Dev M1 01-Jul-2015 31-Aug-2015
App1 Dev M2 15-Aug-2015 15-Sep-2015
App1 Dev M3 01-Sep-2015 13-Sep-2015
App2 Dev M1 01-Jul-2015 31-Aug-2015
App2 Dev M2 15-Aug-2015 15-Sep-2015
App2 Dev M3 01-Sep-2015 13-Sep-2015
App2 UAT M1 01-Jul-2015 31-Aug-2015
App2 UAT M2 15-Aug-2015 15-Sep-2015
App2 UAT M3 01-Sep-2015 13-Sep-2015

Sheet 2 is the Summary level information, table as below
Application Id Environment Name Start Date End Date
App1 Dev
App2 Dev
App2 UAT


Need to know the Start date and End date in Sheet 2 using VBA.

Thanks for helping me out.

Regards
Ashish

 

[Nebu]

Hi:

This is possible, but please take some pain to upload a sample workbook, do not expect the forum members to create a sample workbook and do the coding for you.

Thanks

 

[ajoshi76]

I apologize for the same. I am uploading the excel workbook.

 

[Nebu]

Hi:

Please find the attached.

Thanks

 

[ajoshi76]

Fabulous... Thank you very much