Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-16 Thread Dilip Pandey
You are always welcome Greg... :) It would be good if you start a new thread (query posting) in future with a nice subject line so that every one can help you and learn with your challenge(s). :) Best Regards, DILIPandey On Thu, Sep 16, 2010 at 3:04 PM, gdbar...@googlemail.com < gdbar...@google

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-16 Thread gdbar...@googlemail.com
Hi Dilip Thanks so much for the workbook - it's great. I have some more work to do on the project. So I may need your help again in the future?! Do you think it is best to re-submit to this post? Or start a new thread? Thanks again. Greg On 11 Sep, 16:26, Dilip Pandey wrote: > Hi Greg, > >

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-11 Thread Dilip Pandey
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

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-11 Thread Dilip Pandey
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, DILIPande

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-11 Thread solomon raju
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 wrote:

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-11 Thread Dilip Pandey
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 wrote: > Thanks Dilip - I've uploaded the file 'sample.xlsx' > > Regards, Greg > > > On 9 Sep, 15:52, Dilip Pandey wrote: >> Hi Greg, >> >> Ple

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-09 Thread gdbar...@googlemail.com
Thanks Dilip - I've uploaded the file 'sample.xlsx' Regards, Greg On 9 Sep, 15:52, Dilip Pandey wrote: > Hi Greg, > > Please share a sample file with the Group.  Thanks > > Best Regards, > DILIPandey > > On 9/9/10, gdbar...@googlemail.com wrote: > > > > > Hi > > > I'm trying to work out how I

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-09 Thread Dilip Pandey
Hi Greg, Please share a sample file with the Group. Thanks Best Regards, DILIPandey On 9/9/10, 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,

$$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-09 Thread gdbar...@googlemail.com
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