Could you please guide me how to populate the rows in the sheet (Report) from different sheet (Datas) based on the selection made in Report Sheet. For example if you select city 'Pune', the rows related to Pune City in 'Datas' sheet should be populated in Report Sheet below the Selection.
Could anyone tell me how to do it in excel 2007?
Regards
Ahamed
Bookmarks