Hi All... I have a Source excel which has 4 sheets,summary, match,source1 unmatch, source2 unmatch, I have a sample Excel with multi select list box populating the unique list of countries, when i select one country or more it has to display the result for those countires, in all the 4 sheets of the sample Excel, With seperate summary tables for each countries with the static text on the sample excel..For source pls refer the Source Excel, to make it clear, if i select 10 countries I need to show 10 summary table for countries separately in summary sheet(sheet1) and the country name has to be populated on the top mentioning its name as in source and 10 countries records in other sheets..match(sheet2),source1 unmatch(sheet3),source2 unmatch(sheet 4), seperately on the respective sheets, summary for each country should display the results by taking it from the rest of 3 sheet values for that country... I am wondering how to do this, If any one can Please help me out.. thanks in advance..
Bookmarks