Dear Mr. Fabio Lemos,
Thanks for your interest. I tried to apply your below mentioned formula. I am getting error message. Can you please send me sample file with formula. Thanks a lot for this kindness. Regards, ZAFAR IQBAL From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Fabio Lemos Sent: Saturday, May 14, 2011 7:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help to make my project good. 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 find 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