I am doing a reconciliation work . i am trying to generate reports on excel from sqlserver.. I created a listbox and able populate country details in it from sqlserver, when i click on selected country it is not getting the records from database... i need the records to populate in same workbook on sheet1,2and 3, like summary,matched and unmatched records.. and i also need to format the summary reports ... any help would be very much appreciated.