Hi Karan, Use this formula,
=OFFSET(IF($A$2="Administration, Business and Office Work",'Administration, Business and Of'!A1,IF($A$2="Building and Construction",'Building and Construction'!B1,'Catering and Hospitality'!A1)),'Building and Construction'!$I$2,0) And copy in all your gray cells Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karan 1237 Sent: Wednesday, May 11, 2011 3:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help to make my project good. 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. Thnx in Advance ııllllııllıı ~ ♣ кαяαηη ♣ ~ ııllllııllıı -- ---------------------------------------------------------------------------------- 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<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- 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
