date:20101118

$$Excel-Macros$$ plz help to automate diet chart

2010-11-18 Thread lucky singh

hi Guys

plz help me to automate diet chart

Regards,
Lucky

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


diet chart.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel Doubt

2010-11-18 Thread sumit kumar

Dear Sumanth

Here is ur solution...hope this solve ur query.

Regards
Sumit

On Fri, Nov 19, 2010 at 9:58 AM, sumanth kumar wrote:

> Dear All,
>
> Can you please provide the formula which directly gives the information
>
> 1) Out of 425 rows are there
> 2) I want to capture the data of largest numbers
> 3) greater than and less than kind of thing
>
>
> Sumanth.
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Doubts_sumit.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Jagadeesh B S

Hi all
I see there is some proble with the data only.which needs some changes to be
done.

Thank you so much for the help.

Thanks
Jagadeesh B S




On Thu, Nov 18, 2010 at 7:56 PM, Ajay Varshney
wrote:

> Problem is with the data on the Data tab.
>
>
> Almost all accounts have more than 1 entry which is causing mismatch in the
> results.
>
>
>
>
>
>
>
>
>
>
> On Thu, Nov 18, 2010 at 6:23 PM, Paul Schreiner wrote:
>
>>  I placed a "=countif" function in the column adjacent to your "test"
>> =IF(H11<>F11,COUNTIF(Data!A:A,A11),"")
>>
>> Now, I have no idea why you think that the account "1960D5" for "Marl"
>> should be 0 when in the Data sheet it has:
>>  1960D5 EUR Marl -1155.19 -1380.34
>>
>> But for the rest of them,
>> most have more than one record in the Data sheet.
>> VLookup only returns the first of the records.
>> If you want it to return a SUM of the records with the matching
>> Account number, we can change the VLookup function to SumIF.
>>
>> In some cases, there is NO matching records, yet YOU think there should
>> be.
>> There ARE matching numbers in your "Sheet3", so
>> clearly something is missing.
>>
>> Also, be careful with the cell formats.
>> In some cases, because the account number contains only numbers,
>> Excel wants to convert it to a number.
>> So, in the Report you put a (') in front like: '247067
>>
>> If in the Data sheet, the Account column is a Text format, this value
>> may not have the leading ('), so it would not find a match.
>>
>> If you have any control over the values, you COULD create
>> a new column and prefix the values with "Z" (or some alpha character)
>>
>> Paul
>>
>>
>>  *From:* Jagadeesh B S 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Thu, November 18, 2010 1:18:24 AM
>> *Subject:* Re: $$Excel-Macros$$ Help required for formule
>>
>>
>> Hello friends my requirement is met in some way but not the complete
>> solution.
>>
>> Thanks a lot to Paul for the help.
>>
>> This formula helped me a bit but not able to do well as per my
>> requirement. Could you please look it to the attachment and help me
>> again...?
>>
>> Thanks for your valuable assistance.
>>
>> Thanks
>> Jagadeesh B S
>>
>>
>>
>> On Wed, Nov 17, 2010 at 6:56 PM, Paul Schreiner 
>> wrote:
>>
>>>  Your formula for row 3 would look like:
>>>
>>> =IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))
>>> Paul
>>>
>>>
>>> *From:* Jagadeesh B S 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Wed, November 17, 2010 7:45:42 AM
>>> *Subject:* $$Excel-Macros$$ Help required for formule
>>>
>>>  Hello Friends
>>>
>>> I need a formula or macro( preferabley formule) need to prepare this
>>> report .
>>>
>>> I need a formula which should get the details for the account # mentioned
>>> in the column A with the reference to the currency,form the sheet DATA, if
>>> the currency is USD It should pull the value in the column E and if the
>>> currency is other then USD it should pull the value in the column D.
>>>
>>>
>>>
>>> Please help with this formula…
>>>
>>>
>>>
>>> Thanks you very much.:)
>>>
>>> --
>>>
>>> --
>>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>>   --
>>>
>>> --
>>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>> --
>>
>> --
>> 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. L

$$Excel-Macros$$ Excel Doubt

2010-11-18 Thread sumanth kumar

Dear All,

Can you please provide the formula which directly gives the information

1) Out of 425 rows are there
2) I want to capture the data of largest numbers
3) greater than and less than kind of thing


Sumanth.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Doubts.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

2010-11-18 Thread in . vaibhav

Hi,

Why VBA code, use PDF to Word converter. Just Google it on internet it can 
covert multiple files in once shot also.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: ashish koul 
Sender: excel-macros@googlegroups.com
Date: Fri, 19 Nov 2010 03:38:02 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

can you attach and  send some  pdf docs

On Thu, Nov 18, 2010 at 12:19 AM, RKM  wrote:

> Hi Experts
>
> I am waiting for over 10 days for the below request to convert PDF
> file to RTF file format.
>
> For better understanding Please find the below.
>
> 1. Usually I will recieve n number of PDF per day.
> 2. I have to change the file in to RTF format (Ms WOrd).
> 3. Now I am open the PDF file and copy the content and paste it in a
> blank document (MS WORD).
> 4. Save the Document as RTF format.
>
> I can do it if i get 5 to 10 files. But I am struggling to do this if
> I gets more than 20 files. Now I am expecting for any code for doing
> the above task via VBA or Macro or any other Kind.
>
> It would be helpful if I get soon reply for this as i geting over 25 -
> 50 files day to day.
>
>
> Maariappan .R .K
>
>
> On Nov 12, 1:58 pm, RKM  wrote:
> > Hi Friends,
> >
> > Is there any one has any idea about to resolve the below request
> > through VBA or any other...
> >
> > By R. K. Maariappan
> >
> > On Nov 3, 5:20 pm, RKM  wrote:
> >
> >
> >
> > > Hi Experts,
> >
> > > Usually I will get some files for process in PDF format. But I could
> > > not do the regular process in the same format. So I must convert the
> > > PDF file toRTFfile. Please find the steps I do for this task.
> >
> > > 1. Open the PDF File.
> > > 2. Copy the contents using Cntl+A key
> > > 3. Open a blank Document (Word doc).
> > > 4. Paste the copied contents.
> > > 5. Use the save as the document inRTFformat.
> >
> > > This has to be done for each and every File I got. This will be easy
> > > if i got 5 - 10 files. But I may get N number of Incoming per day.
> >
> > > The Help Required:
> >
> > > Now I wish to know is there any code to execute the task via Macros.
> > > If so please let me know the code or any alternate for this task.- Hide
> quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

2010-11-18 Thread ashish koul

can you attach and  send some  pdf docs

On Thu, Nov 18, 2010 at 12:19 AM, RKM  wrote:

> Hi Experts
>
> I am waiting for over 10 days for the below request to convert PDF
> file to RTF file format.
>
> For better understanding Please find the below.
>
> 1. Usually I will recieve n number of PDF per day.
> 2. I have to change the file in to RTF format (Ms WOrd).
> 3. Now I am open the PDF file and copy the content and paste it in a
> blank document (MS WORD).
> 4. Save the Document as RTF format.
>
> I can do it if i get 5 to 10 files. But I am struggling to do this if
> I gets more than 20 files. Now I am expecting for any code for doing
> the above task via VBA or Macro or any other Kind.
>
> It would be helpful if I get soon reply for this as i geting over 25 -
> 50 files day to day.
>
>
> Maariappan .R .K
>
>
> On Nov 12, 1:58 pm, RKM  wrote:
> > Hi Friends,
> >
> > Is there any one has any idea about to resolve the below request
> > through VBA or any other...
> >
> > By R. K. Maariappan
> >
> > On Nov 3, 5:20 pm, RKM  wrote:
> >
> >
> >
> > > Hi Experts,
> >
> > > Usually I will get some files for process in PDF format. But I could
> > > not do the regular process in the same format. So I must convert the
> > > PDF file toRTFfile. Please find the steps I do for this task.
> >
> > > 1. Open the PDF File.
> > > 2. Copy the contents using Cntl+A key
> > > 3. Open a blank Document (Word doc).
> > > 4. Paste the copied contents.
> > > 5. Use the save as the document inRTFformat.
> >
> > > This has to be done for each and every File I got. This will be easy
> > > if i got 5 - 10 files. But I may get N number of Incoming per day.
> >
> > > The Help Required:
> >
> > > Now I wish to know is there any code to execute the task via Macros.
> > > If so please let me know the code or any alternate for this task.- Hide
> quoted text -
> >
> > - Show quoted text -
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Need Urgent Help

2010-11-18 Thread ashish koul

hi

check the attachment see if helps .it will copy whole pdf documnet

make sure you change this path according to ur pdf setup.


"C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe"






On Thu, Nov 18, 2010 at 2:39 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:

> Hi friends,
>
> Please helps  in this concern i have around 100 pdf documents in sharedrive
> ,
>
> i need to open each single pdf document and Copy the customer name and
> amount
>
> and store in one excel file.
>
> Please advise the formula to pick this details from PDF.
>
> Customer name:
> Amount :
>
> and this details should be noted in one excel sheet.
>
>
> Thanks,
> Raj
>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts


copy from pdf to excel.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Ajay Varshney

Problem is with the data on the Data tab.


Almost all accounts have more than 1 entry which is causing mismatch in the
results.










On Thu, Nov 18, 2010 at 6:23 PM, Paul Schreiner wrote:

>  I placed a "=countif" function in the column adjacent to your "test"
> =IF(H11<>F11,COUNTIF(Data!A:A,A11),"")
>
> Now, I have no idea why you think that the account "1960D5" for "Marl"
> should be 0 when in the Data sheet it has:
>  1960D5 EUR Marl -1155.19 -1380.34
>
> But for the rest of them,
> most have more than one record in the Data sheet.
> VLookup only returns the first of the records.
> If you want it to return a SUM of the records with the matching
> Account number, we can change the VLookup function to SumIF.
>
> In some cases, there is NO matching records, yet YOU think there should be.
> There ARE matching numbers in your "Sheet3", so
> clearly something is missing.
>
> Also, be careful with the cell formats.
> In some cases, because the account number contains only numbers,
> Excel wants to convert it to a number.
> So, in the Report you put a (') in front like: '247067
>
> If in the Data sheet, the Account column is a Text format, this value
> may not have the leading ('), so it would not find a match.
>
> If you have any control over the values, you COULD create
> a new column and prefix the values with "Z" (or some alpha character)
>
> Paul
>
>
>  *From:* Jagadeesh B S 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, November 18, 2010 1:18:24 AM
> *Subject:* Re: $$Excel-Macros$$ Help required for formule
>
>
> Hello friends my requirement is met in some way but not the complete
> solution.
>
> Thanks a lot to Paul for the help.
>
> This formula helped me a bit but not able to do well as per my requirement.
> Could you please look it to the attachment and help me again...?
>
> Thanks for your valuable assistance.
>
> Thanks
> Jagadeesh B S
>
>
>
> On Wed, Nov 17, 2010 at 6:56 PM, Paul Schreiner wrote:
>
>>  Your formula for row 3 would look like:
>>
>> =IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))
>> Paul
>>
>>
>> *From:* Jagadeesh B S 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wed, November 17, 2010 7:45:42 AM
>> *Subject:* $$Excel-Macros$$ Help required for formule
>>
>>  Hello Friends
>>
>> I need a formula or macro( preferabley formule) need to prepare this
>> report .
>>
>> I need a formula which should get the details for the account # mentioned
>> in the column A with the reference to the currency,form the sheet DATA, if
>> the currency is USD It should pull the value in the column E and if the
>> currency is other then USD it should pull the value in the column D.
>>
>>
>>
>> Please help with this formula…
>>
>>
>>
>> Thanks you very much.:)
>>
>> --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>>   --
>>
>> --
>> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=

$$Excel-Macros$$ How to Schedule a VBA Macro?

2010-11-18 Thread OpenExcel.com

Guys, ever wondered about setting Alarm or Scheduling VBA macros in MS
Excel.
Please visit: 
http://www.excelitems.com/2010/11/schedule-vba-macro-alarm-setting.html


Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread Paul Schreiner

I placed a "=countif" function in the column adjacent to your "test"
=IF(H11<>F11,COUNTIF(Data!A:A,A11),"")

Now, I have no idea why you think that the account "1960D5" for "Marl"
should be 0 when in the Data sheet it has:
1960D5 EUR Marl -1155.19 -1380.34 

But for the rest of them,
most have more than one record in the Data sheet.
VLookup only returns the first of the records.
If you want it to return a SUM of the records with the matching
Account number, we can change the VLookup function to SumIF.

In some cases, there is NO matching records, yet YOU think there should be.
There ARE matching numbers in your "Sheet3", so
clearly something is missing.

Also, be careful with the cell formats.
In some cases, because the account number contains only numbers,
Excel wants to convert it to a number.
So, in the Report you put a (') in front like: '247067

If in the Data sheet, the Account column is a Text format, this value
may not have the leading ('), so it would not find a match.

If you have any control over the values, you COULD create
a new column and prefix the values with "Z" (or some alpha character)

Paul


>
>From: Jagadeesh B S 
>To: excel-macros@googlegroups.com
>Sent: Thu, November 18, 2010 1:18:24 AM
>Subject: Re: $$Excel-Macros$$ Help required for formule
>
>
>
>
>Hello friends my requirement is met in some way but not the complete solution.
>
>
>Thanks a lot to Paul for the help.
>
>
>This formula helped me a bit but not able to do well as per my requirement. 
>Could you please look it to the attachment and help me again...?
>
>
>Thanks for your valuable assistance.
>
>
>Thanks 
>Jagadeesh B S
>
>
>
>
>
>On Wed, Nov 17, 2010 at 6:56 PM, Paul Schreiner  wrote:
>
>Your formula for row 3 would look like:
>>
>>=IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))
>>
>>Paul
>>
>>>
>>>From: Jagadeesh B S 
>>>To: excel-macros@googlegroups.com
>>>Sent: Wed, November 17, 2010 7:45:42 AM
>>>Subject: $$Excel-Macros$$ Help required for formule
>>>
>>>
>>>
>>>Hello Friends
>>>I need a formula or macro( preferabley formule) need to prepare this report .
>>>I need a formula which should get the details for the account # mentioned in 
>>>the 
>>>column A with the reference to the currency,form the sheet DATA, if the 
>>>currency 
>>>is USD It should pull the value in the column E and if the currency is other 
>>>then USD it should pull the value in the column D.
>>> 
>>>Please help with this formula…
>>> 
>>>Thanks you very much.:)
>>>
>>>-- 
>>>--
>>>
>>>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>-- 
>>--
>>
>>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>-- 
>--
>
>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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
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=187

$$Excel-Macros$$ Validate an E-mail Address

2010-11-18 Thread OpenExcel.com

Visit:
http://www.excelitems.com/2010/11/validate-e-mail-addresses.html



Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: how dectec the mouse over an userform

2010-11-18 Thread OpenExcel.com

Hi Alfred,

You may try MouseMove event of Userform as follows:

Private Sub UserForm_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
'--YOUR CODE--
End Sub




Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com



On Nov 18, 3:11 pm, Alfred WALLACE  wrote:
> Hi to all gurus (day gurus, or night gurus !)
>
> My problem is in the objet of that post.
>
> I would like to detect when the user put the mouse
> over a "non modal" userform.
>
> I make (with a lot of guru's help) an non-modal-ontopscreen userform.
> this userform is "transparent", that works.
>
> Now, when the user put the mouse over my userform, i want
> to give 0% of transparence. And return to the original transparence
> (50%
> for exemple) when the user puts the mouse on other part of sur screen.
>
> Can I dectect the fly, on, and off the mouse, over my USF ?
>
> thanks again for your help
>
> José from france

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ how dectec the mouse over an userform

2010-11-18 Thread Alfred WALLACE

Hi to all gurus (day gurus, or night gurus !)

My problem is in the objet of that post.

I would like to detect when the user put the mouse
over a "non modal" userform.

I make (with a lot of guru's help) an non-modal-ontopscreen userform.
this userform is "transparent", that works.

Now, when the user put the mouse over my userform, i want
to give 0% of transparence. And return to the original transparence
(50%
for exemple) when the user puts the mouse on other part of sur screen.

Can I dectect the fly, on, and off the mouse, over my USF ?

thanks again for your help

José from france

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ time running

2010-11-18 Thread johnson john

just try this.,

Sub Y_1()
Range("a1") = Format(Now(), "HH:MM:SS")
Application.OnTime Now() + TimeValue("00:00:01"), "Y_1"
End Sub

Best regards.,

On Thu, Nov 18, 2010 at 12:50 PM, siti Vi  wrote:

> Anda belum searching di old posting milis XL-mania  ataupun belajar-excel ?
>
>
>
> On 11/18/10, ratu elissa  wrote:
> > hot to create time update per second in vba
> >
> > --
> >
> --
> > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
> >
>
> --
>
> --
> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Johnson Dara
American Power Conversion
Lavelle Road
Bangalore 560 001

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR

2010-11-18 Thread Sundeep Kumar

Dude best thing to do is practice it yourself .

 

Record macros first and then analyze it to understand the commands there are
some good books which will get you through VBA macros.

 

Regards,

Sundeep Kumar

 

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, November 18, 2010 10:37
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN
ADVANCE EXCEL AND VBA MACROS AT JAIPUR

 

IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT
JAIPUR.


PLEASE SUGGEST ME.

AWAITING FOR YOUR RESPONSE.


REGARDS
AMIT

-- 

--
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/pages/discussexcelcom/160307843985936?v=wall
 &ref=ts

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Help required for formule

2010-11-18 Thread OpenExcel.com

Hi Jagadeesh,

I find Paul formula to be 100% correct as per we both are able to
understand your problem. If Paul's formula is not justifying your
problem completely then please elaborate your problem efficiently.



Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com


On Nov 18, 11:18 am, Jagadeesh B S  wrote:
> Hello friends my requirement is met in some way but not the complete
> solution.
>
> Thanks a lot to Paul for the help.
>
> This formula helped me a bit but not able to do well as per my requirement.
> Could you please look it to the attachment and help me again...?
>
> Thanks for your valuable assistance.
>
> Thanks
> Jagadeesh B S
>
> On Wed, Nov 17, 2010 at 6:56 PM, Paul Schreiner wrote:
>
>
>
>
>
>
>
> > Your formula for row 3 would look like:
>
> > =IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE))
> > Paul
>
> > *From:* Jagadeesh B S 
> > *To:* excel-macros@googlegroups.com
> > *Sent:* Wed, November 17, 2010 7:45:42 AM
> > *Subject:* $$Excel-Macros$$ Help required for formule
>
> >  Hello Friends
>
> > I need a formula or macro( preferabley formule) need to prepare this report
> > .
>
> > I need a formula which should get the details for the account # mentioned
> > in the column A with the reference to the currency,form the sheet DATA, if
> > the currency is USD It should pull the value in the column E and if the
> > currency is other then USD it should pull the value in the column D.
>
> > Please help with this formula…
>
> > Thanks you very much.:)
>
> > --
>
> > --- 
> > ---
> > 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> >  --
>
> > --- 
> > ---
> > 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
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
>
>
>  Help required.xlsx
> 43KViewDownload

-- 
--
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/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ plz help to automate diet chart

Re: $$Excel-Macros$$ Excel Doubt

Re: $$Excel-Macros$$ Help required for formule

$$Excel-Macros$$ Excel Doubt

Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

Re: $$Excel-Macros$$ Re: Convert PDF files to RTF File.

Re: $$Excel-Macros$$ Need Urgent Help

Re: $$Excel-Macros$$ Help required for formule

$$Excel-Macros$$ How to Schedule a VBA Macro?

Re: $$Excel-Macros$$ Help required for formule

$$Excel-Macros$$ Validate an E-mail Address

$$Excel-Macros$$ Re: how dectec the mouse over an userform

$$Excel-Macros$$ how dectec the mouse over an userform

Re: $$Excel-Macros$$ time running

RE: $$Excel-Macros$$ IS THERE ANY GOOD PERSON/INSTITUTE TO LEARN ADVANCE EXCEL AND VBA MACROS AT JAIPUR

Re: $$Excel-Macros$$ Help required for formule

16 matches

Site Navigation

Mail list logo

Footer information