Dear Solomon, There are many websites, including this Group are there to learn Advanced Excel. See the footnote of this email message where some links are given to learn Excel and Macros.Alternatively, you can search "Advanced Excel Tutorials" over Google / other search engines.
In order to learn Macros, I would recommend you to start recording macros using record macro option of Excel and then watch out and relate the steps which you had taken and understand their respective coding in Visual Basic Editor (Alt + F11). Best of luck, DILIPandey On 9/11/10, solomon raju <faithful1...@gmail.com> wrote: > Thanks for your swift reply Mr.Dilip! > Also can you suggest some websites which teach Advanced Excel and how to > create macros! > > Regards, > Solomon > > On Sat, Sep 11, 2010 at 7:56 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > >> Hi Solomon, >> >> That's really Nice.... !! >> Please start contributing and helping others by solving their queries >> and start educating yourself. This way, you can encounter various >> types of realistic Excel queries and can learn advanced Excel. >> Googling is also a good option. :) >> >> Best of luck, >> DILIPandey >> >> On 9/11/10, solomon raju <faithful1...@gmail.com> wrote: >> > Hi All! >> > >> > I would like to learn Advanced Excel and Macros also. I know Vlookup & >> > Hlookup and other formulas. Myself am a bit strong in excel but I want >> to >> > improve more and would like to achieve more success. >> > >> > Please guide me! >> > >> > Regards, >> > Solomon >> > >> > On Sat, Sep 11, 2010 at 7:26 PM, Dilip Pandey <dilipan...@gmail.com> >> wrote: >> > >> >> Hi Greg, >> >> >> >> Please find the attached workbook and let me know if this solves your >> >> purpose :) >> >> >> >> Best Regards, >> >> DILIPandey >> >> >> >> >> >> On 9/9/10, gdbar...@googlemail.com <gdbar...@googlemail.com> wrote: >> >> > Thanks Dilip - I've uploaded the file 'sample.xlsx' >> >> > >> >> > Regards, Greg >> >> > >> >> > >> >> > On 9 Sep, 15:52, Dilip Pandey <dilipan...@gmail.com> wrote: >> >> >> Hi Greg, >> >> >> >> >> >> Please share a sample file with the Group. Thanks >> >> >> >> >> >> Best Regards, >> >> >> DILIPandey >> >> >> >> >> >> On 9/9/10, gdbar...@googlemail.com <gdbar...@googlemail.com> wrote: >> >> >> >> >> >> >> >> >> >> >> >> > Hi >> >> >> >> >> >> > I'm trying to work out how I can automate (macro or formula) >> finding >> >> >> > specific data in a xls and returning the data in a nearby column. >> >> >> >> >> >> > More sepcifically, all the worksheets I'm using include a revenue >> >> >> > total and by this total there is always the text 'ex VAT' (this >> >> >> > always >> >> >> > only appears once on a worksheet). I'd like to find 'ex Vat' and >> >> >> > return the total revenue in the column 2 to the right and group >> these >> >> >> > together on a summary sheet. My attempt is: =IF(A1:F100="ex >> >> >> > vat",2,0)* >> >> >> >> >> >> > * = is the area where the data can be found (could it be the >> >> >> > entire >> >> >> > worksheet?) >> >> >> >> >> >> > Can anyone suggest a formula? >> >> >> >> >> >> > Thanks in advance >> >> >> >> >> >> > Greg >> >> >> >> >> >> > -- >> >> >> > >> >> >> ---------------------------------------------------------------------------------- >> >> >> > 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 athttp://www.excel-macros.blogspot.com >> >> >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> >> >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> >> >> >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> >> >> >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> >> >> > HELP US GROW !! >> >> >> >> >> >> > We reach over 7000 subscribers worldwide and receive many nice >> notes >> >> >> > about >> >> >> > the learning and support from the group.Let friends and co-workers >> >> know >> >> >> > they >> >> >> > can subscribe to group at >> >> >> >http://groups.google.com/group/excel-macros/subscribe >> >> >> >> >> >> -- >> >> >> Thanks & Regards, >> >> >> >> >> >> DILIP KUMAR PANDEY >> >> >> MBA-HR,B.Com(Hons),BCA >> >> >> Mobile: +91 9810929744 >> >> >> dilipan...@gmail.com >> >> >> dilipan...@yahoo.com >> >> >> New Delhi - 62, India >> >> > >> >> > -- >> >> > >> >> >> ---------------------------------------------------------------------------------- >> >> > 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 >> >> > >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> >> > HELP US GROW !! >> >> > >> >> > We reach over 7000 subscribers worldwide and receive many nice notes >> >> about >> >> > the learning and support from the group.Let friends and co-workers >> know >> >> they >> >> > can subscribe to group at >> >> > http://groups.google.com/group/excel-macros/subscribe >> >> > >> >> >> >> >> >> -- >> >> Thanks & Regards, >> >> >> >> DILIP KUMAR PANDEY >> >> MBA-HR,B.Com(Hons),BCA >> >> Mobile: +91 9810929744 >> >> dilipan...@gmail.com >> >> dilipan...@yahoo.com >> >> New Delhi - 62, India >> >> >> >> -- >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> 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 >> >> >> >> <><><><><><><><><><><><><><><><><><><><><><> >> >> HELP US GROW !! >> >> >> >> We reach over 7000 subscribers worldwide and receive many nice notes >> about >> >> the learning and support from the group.Let friends and co-workers know >> >> they >> >> can subscribe to group at >> >> http://groups.google.com/group/excel-macros/subscribe >> >> >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > 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 >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 7000 subscribers worldwide and receive many nice notes >> about >> > the learning and support from the group.Let friends and co-workers know >> they >> > can subscribe to group at >> > http://groups.google.com/group/excel-macros/subscribe >> > >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
