1) I have multiple data sheets by countries. The rows and columns ar
fixed. I would like to consolidate all data and sort by top 10 or to
50. What is the best way?

2) If i need to insert new sheets for new country. Can i have the sam
format automatically everytime i insert or do i have to copy an
paste?

3) After inserting a sheet, how can i consolidate the data in the ne
sheet?

Than

--
Message posted from http://www.ExcelForum.com