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

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

Re: $$Excel-Macros$$ Excel Doubt

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 nu

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

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 wh

$$Excel-Macros$$ Excel Doubt

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. -- -

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

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-

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 pe

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

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 fri

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

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,

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

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 Certifi

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

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 h

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

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

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

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 Ind

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

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

Re: $$Excel-Macros$$ time running

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, r

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

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 Be

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

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 Indi