Awesome Rajan, Can you please share your code with us, if possible???
I'm working on the same kind of stuff and your code might be helpful in that. Thanks, Manoj Kumar On Sat, Apr 9, 2011 at 12:30 AM, rajan verma <rajanverma1...@gmail.com>wrote: > > HI Karan.. > find the attached sheet.. hope it will complete your task, > > Rajan. > > On Thu, Apr 7, 2011 at 9:41 AM, karan 1237 <karan1...@gmail.com> wrote: > >> >> *Hi Sirs, >> >> I'v to pick data from all occupation. >> >> * <http://www.onetonline.org/link/summary/17-2011.00#Tasks>* >> >> LINK : http://www.onetonline.org/find/career?c=15&g=Go >> >> * >> First of all click on any occupation Like AEROSPACE ENGINEERS it has these >> categories.. >> Tasks <http://www.onetonline.org/link/summary/17-2011.00#Tasks> | Tools >> & >> Technology<http://www.onetonline.org/link/summary/17-2011.00#ToolsTechnology> >> | >> Knowledge <http://www.onetonline.org/link/summary/17-2011.00#Knowledge> | >> Skills <http://www.onetonline.org/link/summary/17-2011.00#Skills> | >> Abilities <http://www.onetonline.org/link/summary/17-2011.00#Abilities> | >> Work >> Activities<http://www.onetonline.org/link/summary/17-2011.00#WorkActivities> >> | Work >> Context <http://www.onetonline.org/link/summary/17-2011.00#WorkContext> | >> Job >> Zone <http://www.onetonline.org/link/summary/17-2011.00#JobZone> | >> Education <http://www.onetonline.org/link/summary/17-2011.00#Education> | >> Interests <http://www.onetonline.org/link/summary/17-2011.00#Interests> | >> Work >> Styles <http://www.onetonline.org/link/summary/17-2011.00#WorkStyles> | >> Work Values<http://www.onetonline.org/link/summary/17-2011.00#WorkValues> | >> Related >> Occupations<http://www.onetonline.org/link/summary/17-2011.00#RelatedOccupations> >> | Wages >> & >> Employment<http://www.onetonline.org/link/summary/17-2011.00#WagesEmployment> >> | Additional >> Information<http://www.onetonline.org/link/summary/17-2011.00#AdditionalInformation> >> >> I'v to pick all data of occupation in same format which i'v attached. >> Kindly help me. >> >> Pls find attachement >> >> Thnx >> Karan >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > > ---------------------------------------------------------------------------------- > 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 > -- ---------------------------------------------------------------------------------- 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
