Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy data from master sheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy specific information from a master sheet? | Excel Worksheet Functions | |||
How can I get data to automatically update using a master sheet? | Excel Worksheet Functions | |||
Create a copy with all data linked to the master | Excel Discussion (Misc queries) | |||
Moving data from master sheet to new sheets | Excel Worksheet Functions | |||
Sorting data in a master sheet | Excel Worksheet Functions |