Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please ignore previous mail..use it Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range("D4:D10") For Each cell In rng1 If cell.Value = rng.Value Then MsgBox "Bill is made of this Chassis", vbInformation Exit Function End If Next cell End Func

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Excel 2007 File Type Extension - xlsx - Excel 2007 XML Workbook - xlsm - Excel 2007 XML Macro-Enabled Workbook - xltx - Excel 2007 XML Template - xltm - Excel 2007 XML Macro-Enabled Template - xlsb - Excel 2007 binary wo

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear Ashish, Please try below code... Function check_value(rng As Range) As String Dim cell, rng1 As Range Set rng1 = Sheet2.Range("D4:D10") For Each cell In rng1 If cell.Value = rng.Value Then MsgBox "Bill is made of this Chassis", vbInformation End If Exit Function Next cell End Function see a

Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. If matc

Re: $$Excel-Macros$$ Copy data from excelsheet to html file

Dear Sushil, Please check below link for your query.. http://www.teachexcel.com/excel-help/excel-how-to.php?i=294897#22 or pls share your worksheet with group, What you want exactly On Thu, Jan 19, 2012 at 2:00 AM, Sushil Kumar wrote: > Hi, > > Please help me on the subjected query. is there an

$$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Dear experts, I have lower level knowledge in excel vba, so please check below coding which not working. I need the Msgbox when entered value match from another sheet. The example sheet attached herewith. Please also know the basic rules of how to use excel function in Visual Basic. Kindly solve

Re: $$Excel-Macros$$ code

Most Welcome Muneer.. On Thu, Jan 19, 2012 at 11:20 AM, Mohammed Muneer wrote: > Mr. Noorain excellent! job, > > ** ** > > Keep it up! > > ** ** > > Miraculous, I was fed with the previous one whenever I prepared the > monthly reports. > > ** ** > > Anyway Thanx a loo

RE: $$Excel-Macros$$ code

Mr. Noorain excellent! job, Keep it up! Miraculous, I was fed with the previous one whenever I prepared the monthly reports. Anyway Thanx a lot, Praises, Prosperity & Prayers, Muneer, CC.. From: excel-macros@goo

$$Excel-Macros$$ Copy data from excelsheet to html file

Hi, Please help me on the subjected query. is there any macro which can copy data from excelsheet and paste on the html/web file? please advcie... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

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

Another possibility- check all your loops with counters. One of them may be exceeding the limits set up by the dimensions of the variable you are using. On Jan 17, 6:28 am, Secret Shot wrote: > Dear Group, > > I have design a VBA tool to capture data on Excel sheet. In this tool we > fill a VBA F

$$Excel-Macros$$ EXCEL - TIPS

Dear Sir/Madam, Kindly i am very much interest to learn excel. Kindly provide the basic and also some important functionslike HLOOKUP,VLOOKUP, MACROS. Thanking you, Regards, kishore -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ RE: ACCESS QUERY

Dear XLStime, This is exactly what I wanted. But I wanted to know the steps to prepare the report since I have to do it for 2500 dealers for 100 schemes. Thanks in advance. Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar

Re: $$Excel-Macros$$ Vlookup Help

Dear Rajan, Try this... =IF(C2="EQUITY SHARE",VLOOKUP(A2,'EQUITY SHARE'!$A$2:$B$17,2,FALSE),IF(C2="DEBENTURE",VLOOKUP(A2,DEBENTURE!$A$2:$B$4,2,FALSE),IF(C2="MUTUAL FUND",VLOOKUP(A2,'MUTUAL FUND'!$A$2:$B$4,2,FALSE),0))) Regards Ashish Bhalara On Wed, Jan 18, 2012 at 7:58 PM, Rajan_Verma wrote:

Re: $$Excel-Macros$$ Question in Excel

Hi Rajan, Thanks a lots for solving my queries. On Wed, Jan 18, 2012 at 9:09 PM, Rajan_Verma wrote: > Try this: > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *neil johnson > *Sent:* Jan/Tue/2012 10:05 > *To:* excel-macro

RE: $$Excel-Macros$$ regarding rounding off

Shankar, I just found your original question and I see you want to implement this in VBA. This is the equivalent VBA, without resorting to referring to worksheet functions: Function RoundUpSpecial(x As Double) As Double RoundUpSpecial = (Fix(x / 10) + IIf(Fix(x) / 10 = Fix(x / 10), 0, Sgn

RE: $$Excel-Macros$$ regarding rounding off

Hello Shankar, The closest single function would be MROUND, but it rounds up and down, and doesn't ignore the fractional part as you specified. See if this meets your needs: =ROUNDUP(TRUNC(number)/10,0)*10 Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]

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

Hi Rajan, You are a champ and it's working perfectly, thnaks so much One more thing here: When the previous code in the worksheet change was used, I could select the Booking Ref from Cell "O4" and populate as per the Booking Ref on the Form, but with the new codes you provided now I cannot, I

Re: $$Excel-Macros$$ Urgent Required

Hi Neeraj Mr Noorain has already reply for this please explain in detail if you are looking apart from this http://groups.google.com/group/excel-macros/msg/5ab13460ec7b96c6?pli=1 HTH Mahesh On Wed, Jan 18, 2012 at 11:06 PM, xlstime wrote: > what you want? > > > On Tue, Jan 17, 2012 at 12:46 P

Re: $$Excel-Macros$$ Need help in building pivot using vba

Hi Rekha Try : Sub Mtest() On Error Resume Next 'delete existing pivot sheet Application.DisplayAlerts = False Sheets("Pivot West").Delete Application.DisplayAlerts = True Sheets("West").Select ActiveSheet.UsedRange.Select 'Count the column colcount = Selection.Columns.Count 'Add Dynamic Name Ran

Re: $$Excel-Macros$$ Date format

Thanks alot On 18 January 2012 18:04, NOORAIN ANSARI wrote: > For more details you can click on.. > > http://www.excelbanter.com/showthread.php?t=270957 > > > > > On Wed, Jan 18, 2012 at 9:33 PM, NOORAIN ANSARI > wrote: > >> Dear Vijay, >> >> For Excel 2007+, you can use conditional formatting.

Re: $$Excel-Macros$$ Urgent Required

what you want? On Tue, Jan 17, 2012 at 12:46 PM, Neeraj Chauhan wrote: > Dear All > > The correct sheet attachd > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula

RE: $$Excel-Macros$$

Not getting your query . please explain Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Muhammad Asif Sent: Jan/Wed/2012 01:28 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dear All, I want serial# against

Re: $$Excel-Macros$$ Date format

Dear Vijay, Without using conditonal Formating.. you can use simple A1=TEXT(A1," d") &LOOKUP(DAY(A1),{1,2,3,4,21,22,23,24,31;"st","nd","rd","th","st","nd","rd","th","st"})&TEXT(A1," , ") -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Date format

number =A1&MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)>2)+1),2) Date =TEXT(A4,", d")&MID("thstndrd",(MOD(DAY(A4),10)*AND(MOD(DAY(A4),10)<4,OR(DAY(A4)<11,DAY(A4)>20)))*2+1,2) Don Guillett SalesAid Software dguille...@gmail.com From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar

Re: $$Excel-Macros$$ Date format

For more details you can click on.. http://www.excelbanter.com/showthread.php?t=270957 On Wed, Jan 18, 2012 at 9:33 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > For Excel 2007+, you can use conditional formatting. > > > Let us assume you are formatting M1 > > Select M1 > Format/cells/Number/Cu

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

Try to process your data after applying text format on this Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Jan/Tue/2012 11:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ need to insert comma in each

Re: $$Excel-Macros$$ Date format

Dear Vijay, For Excel 2007+, you can use conditional formatting. Let us assume you are formatting M1 Select M1 Format/cells/Number/Custom Type: dt\h Then select Conditional Formatting: New Rule Formula: =OR(DAY(M1)=3,DAY(M1)=23) Format/Number/Custom Type: d\r\d New Rule Fo

$$Excel-Macros$$ Excel tips

*Hello NOORAIN ANSARI* You send Excel Tips & Tricks Thank you much -- 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 quick at

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

Check all spelling or existence of all Controls and objects. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Secret Shot Sent: Jan/Tue/2012 04:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Getting Error 9 in VBA Dear Group,

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

Find here http://www.hindisociety.com/HindiFonts.htm From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Tue/2012 04:53 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ queary about filter Hello sir, fist of al

RE: $$Excel-Macros$$ Analysis files

What type of financial tools are you looking for.. can you please explain more about Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ankit Agrawal Sent: Jan/Tue/2012 04:47 To: excel-macros Subject: $$Excel-Macros$$ Analysis files Dear All,

$$Excel-Macros$$ Date format

Dear Experts How can I change the date in excel as per following format (1st, 2nd, 3rd,4 th ) 1st January, 2012 2nd January, 2012 3rd January, 2012 4th January, 2012 I shall be thankful if anybody can assist Regards V.Kiran Kumar -- FORUM RULES (986+ members already BANNED for violatio

RE: $$Excel-Macros$$ Urgent Required.xlsx

See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Jan/Tue/2012 12:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent Required.xlsx Dear Experts Kindly find the attached sheet. I want to name

RE: $$Excel-Macros$$ Excel formula for Dates

=Text(YourDate,"mmm-yy") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Imran khan Sent: Jan/Tue/2012 12:25 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel formula for Dates I have date 17-Jan-12. I want formula to get only Jan-1

RE: $$Excel-Macros$$ Question in Excel

Try this: From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Jan/Tue/2012 10:05 To: excel-macros Subject: $$Excel-Macros$$ Question in Excel Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yel

RE: $$Excel-Macros$$ Vlookup Help

See the attached sheet.. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chidurala, Shrinivas Sent: Jan/Mon/2012 09:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Help Dear Team, I am creating macro for

RE: $$Excel-Macros$$ Dairy 2012

Good one.. simple From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of muralidhar e Sent: Jan/Mon/2012 02:22 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dairy 2012 Hi, Dear all wish u happy sankranti(Pongal) and a digital dairy gift fo

Re: $$Excel-Macros$$ for print dialog box in excel vba form

Dear Shankar, Please use it.. Sub show_Printer() Application.Dialogs(xlDialogPrint).Show End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed,

$$Excel-Macros$$ regarding rounding off

Subject: reply regardingrounding off Kind Attention: Paul Schreiner thank you for your reply and sorry for my late response as I am out of town. What I required is: if a result comes to 20.60 or 20.10 (here whatever be the fraction) it should be rounded off to 20 only if a result comes to 21

$$Excel-Macros$$ for print dialog box in excel vba form

Dear Experts Pls provide code line for a command button to invoke Print Dialogue box. thank you -- 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 A

$$Excel-Macros$$ need immediate help for number to text in msexcel-2007

PLS. HELP US HOW TO CONVERT NUMBERS INTO TEXT/ NUMBER IN MSEXCEL-2007 send link to me rgds gs chopare -- 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 N

Re: $$Excel-Macros$$

Dear Asif Kindly let us know which date ? F column or R column and your PO (I column) is "0" for all ,kindly provide one perfect example for what u want On Wed, Jan 18, 2012 at 1:27 PM, Muhammad Asif wrote: > Dear All, > > I want serial# against PO# number in Column T as like mentioned serial#