Hi

I would advise against copying data to other sheets.
Keep all the data you want on the one sheet.
When you want to see data just relating to one Continent, or one Country
just apply a filter.

Assuming your first row is a Header row, select the range of header
cellsDataFilterAutofilter.
Use the dropdown on cell A1 to select America

--
Regards
Roger Govier

"aditya" wrote in message
...
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