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

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

hi Roger,
i appreciate that. But i dont want to use auto filter.
My need is to copy it in another sheet.

Pls help

"Roger Govier" wrote:

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

Please don't multi-post. See responses in .newusers
I've posted a non-array formulas set-up which should appeal to you
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---