If desired, send your file to my address below along with this msg and clear
explanations with before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"aditya" wrote in message
...
hi Don,
please let me know how can i use vlookup to help me out.

"Don Guillett" wrote:

I would use a macro but try using VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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