You also could simplify the formula by inserting the following in the E2 cell:
=OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0) And tham just copy to the other.... 2011/5/13 Zafar Iqbal <ziqba...@gmail.com> > Dear, With due respect to your effort, I tried with a simplified formula > and got the same result. Please the attached file with both formulas. Thanks > > > > Regards, > > ZAFAR IQBAL > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *§»VIPER«§ > *Sent:* Thursday, May 12, 2011 8:36 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Please help to make my project good. > > > > pfa > > On Thu, May 12, 2011 at 12:31 AM, Mahesh parab <mahes...@gmail.com> > wrote: > > Hi > > > > check whether attach file helps. > > On Wed, May 11, 2011 at 3:51 PM, karan 1237 <karan1...@gmail.com> wrote: > > Respected Sirs/Mam, > > I need your help making my project good. Please find attachment. I will be > very obliged if someone can help me as earlier as possible. > > ---------- > Basically I have to do that when I click on drop down list & select another > career i.e. Building and Construction so In sub career list data should > comes from the Building and construction's sheet and If I select another > career i.e. Catering and Hospitality so data should comes from its list > (Catering and Hospitality) and scroll bar should work with the same. I have > 16 careers so please tell me how can I do this. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Fabio Lemos e-mail: flnle...@gmail.com -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel