Then you would want to use pivot tables.

Data Pivot table...

Place your Continent in the Page Field

Then drop your other columns into the Row fields.

You may or may not want subtotals for each. If not, right click and select
Field Settings. then select None under Subtotals.

When using this, you canalso get the sum, average, count, etc. of a colun as
well by dropping into data fields... If you right-click on your table and
select Table Options, you can choose to refresh on open...

"aditya" wrote:

my sheet1 is master sheet where data related to all continent is entered. e.g.
A B C D .......
1 America US Big 1
2 Europe Britain Big 3
3 America Canadan Medium 7

i want my sheet2 to get all information if column A contains america.
(i.e. row 1 & row 3 data) ...i.e. sheet 2 is america specific sheet..
similarly sheet3 to get all data if Column A contains Europe (i.e. row 2
data).
It should update automatically whenever i enter data in master sheet.
i dont want to use macro.

Thanks in advance