Re: $$Excel-Macros$$ regarding number to text

thank you Members, this is great. regds, Sanjib On Tue, Jan 17, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > Yes Sanjib, > > Lakshman is right, > > If you want in Lakh format please check attached sheet. > > Hope it will help to u. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacro

$$Excel-Macros$$ Hands on on Excel

All, Looking for hands-on excel training to work large databases in Indore. Please send references about anyone relevant Regards, Vani Sharma Information transmitted by this e-mail is proprietary to MphasiS, its associated companies and/ or its customers and is intended for use only

Re: $$Excel-Macros$$ Analysis files

Thank you sir, Regards, Ankit On Tue, Jan 17, 2012 at 7:08 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please download PDF file for financial Analysis tools and techniques.. > > http://www.caclubindia.com/share_files/financial-analysis-tools-and-techniques-a-guide-pdf-5677.asp > > > On Tue, Jan

$$Excel-Macros$$ RE ACCESS QUERY

Dear All, Please find enclosed herewith the draft report format in MS Word as an example of how I want the report. Please understand that it is only a small amount of data , the original data contains the schemes earning details of about 2500 dealers for about 100 schemes. Thanks & Regards.

Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please

Rajan, Thank you very much for your help, you are a champ mate... Everything is working fine except that when I click on the getprevious record button it shows/populates the headers from RoomReservation Sheet and shows the following error: "Unable to get the match of the worksheetfunctiopn class

Re: $$Excel-Macros$$ convert numbers into words

Dear Noorain it would be great if could explain about how you have hide formula's by defining "formulahide" (='From Excel'!$W$1:$AG$13) name range on From Excel worksheet Thanks Mahesh On Tue, Jan 17, 2012 at 7:02 PM, Rajan_Verma wrote: > You Inword(Yourdigit) after install this add-in >

Re: $$Excel-Macros$$ Want to see the caption in the button in the toolbar

You don't need such an elaborate code to create your control. Here's a cleaner version... Sub indrajit() With Application On Error Resume Next .CommandBars("Sam Mathai Chacko").Delete With .CommandBars.Add("Sam Mathai Chacko", 4) .Visible = .Enabled

Re: $$Excel-Macros$$ Previous and Next Buttons on Excel Sheet! Help Please

I am of the old school that adheres to the KISS principle. It appears that you try to overcomplicate your code. I am available for custom excel projects at only $75 hourly Sub ViewLogFirstSAS() With Sheets("form") .Select Sheets("RoomReservation").Cells(7, 3).Resize(, 18).Copy .Range("d5").Past

Re: $$Excel-Macros$$ Excel Chart Formatting

Maybe Jon’s site can help http://peltiertech.com/Excel/Charts/index.html or http://www.tushar-mehta.com/ Don Guillett SalesAid Software dguille...@gmail.com From: Steve Weaver Sent: Tuesday, January 17, 2012 5:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-M

$$Excel-Macros$$ JOB

*Experience required for the Job:* 4 - 8 years *Job Location:* Bengaluru/Bangalore *Dear Candidate,* Greetings!!! Hi, Hope you are doing fine!!! We are having the opening in MindTree for MS Access + VBA Lead EXP 4-8Yrs Interview Type - F2F Job Type - 6-8 Months contract,after that hire Dire

Re: $$Excel-Macros$$ Getting Error 9 in VBA

Or, at least post your code Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Tuesday, January 17, 2012 7:16 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Getting Error 9 in VBA Dear Pankaj, If possible, Can you share a sample sheet with group

Re: $$Excel-Macros$$ simple Macro need -SAP data

This formula works if you do not have duplicate product numbers not in the block such as '=SUMPRODUCT(--(sap!$C$8:$C$22=C9)*sap!$E$8:$E$22) 320013 SPENT HCL SOLUTION 27% 320013 H 320013 WIP 08.2011 / H Don Guillett SalesAid Software dguille...@gmail.com From: chandra

RE: $$Excel-Macros$$ Want to see the caption in the button in the toolbar

Hi Hope it will help you http://www.ozgrid.com/VBA/custom-menus.htm Regards Rajan. Verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of INDRAJIT SAHA Sent: Jan/Sun/2012 02:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Want

RE: $$Excel-Macros$$ need to insert comma in each cell ( ' )

Please send some example data to get exact result.. Thanks Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Imran khan Sent: Jan/Tue/2012 07:11 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need to insert comma in each cell ( ' )

$$Excel-Macros$$ need to insert comma in each cell ( ' )

Hi, I am working on file which has been extracted from oracle, and it had comma in each cell. I had change 1000 of cells manually, and comma has been gone. now without comma, i cannot import again. Please help me to put comma in each cell. Regards, Imran Khan -- FORUM RULES (986+ members alre

Re: $$Excel-Macros$$ Analysis files

Dear Ankit, Please download PDF file for financial Analysis tools and techniques.. http://www.caclubindia.com/share_files/financial-analysis-tools-and-techniques-a-guide-pdf-5677.asp On Tue, Jan 17, 2012 at 4:47 PM, Ankit Agrawal wrote: > Dear All, > > I need financial analysis tools file & plz

Re: $$Excel-Macros$$ convert numbers into words

Dear Noorain Excellent Tips.. Thanks Nikhil Shah On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI wrote: > Updated Sheet > > > On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa wrote: > >> Dear Noorain >> >> It converts with Rupees and i want only for words >> >> E.g. I have "23" in A1 so by formula w

RE: $$Excel-Macros$$ Running/Moving Statement

Try this: Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub Start() Dim strText As String strText = Range("rngMyRange").Value strText = Trim(strText) strText = strText & WorksheetFunction.Rept(" ", 40) l = Len(strText) Do DoEvents

Re: $$Excel-Macros$$ Getting Error 9 in VBA

Dear Pankaj, If possible, Can you share a sample sheet with group. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Jan 17, 2012 at 4:58 PM, Secre

Re: $$Excel-Macros$$ convert numbers into words

Dear Priyanka, Please use SpellNumber() function with Substitue Function. *=SUBSTITUTE(SpellNumber(B4),"Rupees ","") * Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ convert numbers into words

Dear Noorain It converts with Rupees and i want only for words E.g. I have "23" in A1 so by formula we need "Twenty Three Only" I hope there may be something in excel treasure for this On Tue, Jan 17, 2012 at 3:54 PM, NOORAIN ANSARI wrote: > Dear Priyanka, > > Please check attached sheet. > Ho

Re: $$Excel-Macros$$ hindi version of excel

Hello sir, I have already load hindi font, when i go filter than data change in diffrent lenguge. anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ hindi version of excel

Dear Anil, *DOWNLOAD* AND INSTALL *HINDI FONTS* dipp.nic.in/*hindi*/*hindifont*page.htm On Tue, Jan 17, 2012 at 5:39 PM, anil kumar wrote: > Hello friends, > > > any body tell me were i can gat hindi version of excel. plz tell me link > > > anil > >

Re: $$Excel-Macros$$ hindi version of excel

Hi Anil, Please check the following link: http://office.microsoft.com/hi-in You can also check the following link: http://www.bollywhat-forum.com/index.php?topic=26611.0 Regards, Aindril On Tue, Jan 17, 2012 at 5:39 PM, anil kumar wrote: > Hello friends, > > > any body tell me were i can gat

$$Excel-Macros$$ hindi version of excel

Hello friends, any body tell me were i can gat hindi version of excel. plz tell me link anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

Re: $$Excel-Macros$$ simple Macro need -SAP data

hi noor can you help me Regards chandru On Tue, Jan 17, 2012 at 12:17 PM, chandra sekaran wrote: > Dear all > > can you please help me . which i attached excell sheet having two > sheets one SAP sheet and output we need product wise sum Qty and Value > if you suggest simple macro > > Tha

$$Excel-Macros$$ Getting Error 9 in VBA

Dear Group, I have design a VBA tool to capture data on Excel sheet. In this tool we fill a VBA Form and data got captured on Excel sheet. But most of the time i am getting Error no 9 "Subscript Out of Range" Unable to identified that why is occure. Kindly Help. -- Pankaj Pandey Bhopal -- FOR

Re: $$Excel-Macros$$ queary about filter

Hello sir, fist of all thanks, were can i gat hindi verson of excel. anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

$$Excel-Macros$$ Analysis files

Dear All, I need financial analysis tools file & plz send me. Regards, Ankit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ queary about filter

Dear Anil, your need to install a hindi language version of excel to show hindi. the filter drop down shows the true character in the cell same thing happens if you format as windings. On Tue, Jan 17, 2012 at 4:10 PM, anil kumar wrote: > Hello group members, > > I have a excel file which have d

$$Excel-Macros$$ queary about filter

Hello group members, I have a excel file which have data in hindi, I have to short by add. can I use filter or any other way plz tell me. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Nee

Re: $$Excel-Macros$$ convert numbers into words

In "From Excel" Sheet i have written 525575 (Five Lac Twenty-Five Thousand Five hundred and Seventy-Five) but we are getting result as per below : (Red highlighted) *Type No Here* 525575 *Convert in Text* five hundred and twenty-five thousand five hundred and seventy-five On Tue, Jan 17,

Re: $$Excel-Macros$$ regarding number to text

Because this vba for million and billion format. For lakh you use other vba code From: Sanjib Chatterjee To: noorain.ansari ; excel-macros Sent: Tuesday, 17 January 2012 1:19 PM Subject: $$Excel-Macros$$ regarding number to text Dear NOORAIN ANSARI, This

Re: $$Excel-Macros$$ convert numbers into words

i think her system macro is disable.   coz, i have checked its working. From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Tuesday, 17 January 2012 1:43 PM Subject: Re: $$Excel-Macros$$ convert numbers into words Hi Priyanka, Can you explain what er

Re: $$Excel-Macros$$ convert numbers into words

Hi Priyanka, Can you explain what error you are getting.. because VBA+Excel both are working fine On Tue, Jan 17, 2012 at 12:56 PM, PrIyAnKa wrote: > Dear Noorain > > Kindly see there is some error in for excel file > > > On Mon, Jan 16, 2012 at 5:07 PM, PrIyAnKa wrote: > >> Thanks Noorain >>