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...@googlemail.com> wrote:

> 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 <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 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
> >
> >  Sample.xlsm
> > 48KViewDownload
>
> --
>
> ----------------------------------------------------------------------------------
> 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

Reply via email to