copy data from master sheet
Please don't multi-post. See responses in .newusers to your identical query.
I've posted a non-array formulas set-up which should appeal to you. Follow-up there. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "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 |
All times are GMT +1. The time now is 06:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com