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