i regular purchase scrips on various dates like reliance, ITC and so many, i insert data in sheet i in col. a; scrip b: purchase date C: amount. how i arrange date wise data of reliance then ITC in sheet#2
but my question is that if i insert data in sheet#1 that should be retrieve automatically scrip wise in sheet#2. for example reliance scrip purchased on 01/08/12, 5/08/12, 10/08/12 data should be like that