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 |
copy data from master sheet
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 |
copy data from master sheet
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 |
copy data from master sheet
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 --- |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com