Code Needed to Update the Summary

Hi,

I have a Summary Sheet and Details Sheet as attached in the excel file i need a Validationa tab in the Summary Sheet highlighted in green Color.The List of the Corporate names are available in details Sheet in Column Y. And there are different types of Statistics in the Summary Sheet which should be updated from the details available.

For example if i get the list of the corporates in the validation tab which are four corporates and if i click on one corporate name then the details should update for that corporate only.

The main required details are highlighted in Green color in details sheet which should be updated in the Summary Sheet all the relevant Information should be updated by clicking on the corporate name. For all the rows from Column number 18 to column number 96 the amount should be updated from Claimed Amount only. If you go through the sheet then you can understand.

Please help as i have around 2000 corporates in my hand as i have do this kind of Summary for them which will take atleast 15 days but the time given to me is only 3 days.

I sincerely request to help me in this aspect.

There is no list in the drop down. Where is the list situated?

You should be able to populate the form using a VLOOKUP or Index/Match.

The List is given below

[/The List of the Corporate names are available in details Sheet in Column Y.]