RE: $$Excel-Macros$$ Re: How to develop Addins

Thanks this would be helpful.. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: 18 December 2012 11:14 To: excel-macros@googlegroups.com Cc: Amit Desai (MERU); Amit Desai (MERU) Subject: $$Excel-Macros$$ Re: How to develop Ad

Re: $$Excel-Macros$$ Merge entry cell

Respected Champs, Can you explain why the exponential function 10^10 is used in the formula =LOOKUP(10^10,E7:H7,E7:H7) i.e 10 to the power of 10 would yield a quite large number and how can it be useful in the look up function. Regards, P.VIJAY KUMAR -- Join official Facebook page of this fo

$$Excel-Macros$$ Re: How to develop Addins

Hi Amit, Please find some useful details on the below mentioned links http://www.microsofttraining.net/article-625-create-excel-vba-add-in.html https://groups.google.com/forum/?hl=en&fromgroups=#!topic/microsoft.public.excel.programming/dV0S4zUgj2o Regards Prince On Monday, 17 December 2012 18

Re: $$Excel-Macros$$ Merge entry cell

Dear Ms-Exl-Learner, As always, Thank you very much for all the help Regards Amar On Tue, Dec 18, 2012 at 10:42 AM, Ms-Exl-Learner wrote: > Not sure whether this... > > For 2003 version of excel > =IF(ISNA(LOOKUP(10^10,E7:H7)),"",LOOKUP(10^10,E7:H7)) > > For excel version which is higher than

Re: $$Excel-Macros$$ Re: Merge entry cell

Hi Rajan That Perfect one Solution Thanks very much. On Mon, Dec 17, 2012 at 4:43 PM, Prince wrote: > Good one Rajan > > Regards > Prince > > > On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote: >> >> In K7 >> >> =INDEX(E7:H7,,MATCH(MAX(**COUNTIF(E7:H7,E7:H7)),COUNTIF(** >> E7:H

$$Excel-Macros$$ Re: Consolidating Multiple files

Hi SG, Please share your file with us. Regards Prince On Friday, 14 December 2012 19:18:59 UTC+5:30, SG wrote: > > Hi Experts, > > I need your help in one of my problem.I want to consolidate the > multiple excel files of a folder with same name & numbered as 1,2,3 in to a > one excel file.I

Re: $$Excel-Macros$$ Merge entry cell

Not sure whether this... For 2003 version of excel =IF(ISNA(LOOKUP(10^10,E7:H7)),"",LOOKUP(10^10,E7:H7)) For excel version which is higher than 2003 =IFERROR(LOOKUP(10^10,E7:H7),"") On 18-12-2012 10:16 AM, amar takale wrote: Dear Parvin, I want like If same number all cell something cell als

Re: $$Excel-Macros$$ Merge entry cell

Dear Parvin, I want like If same number all cell something cell also miss=one number which same If single number=show single number that it simple. I used Ms-Exl-Learner that perfect but if all cell same but last cell different number then show that numbers,I want that time show error then i will

RE: $$Excel-Macros$$ How to creat circle on cells

Hi Pankaj, If you want circles around the cells with values less than 30, there are two methods that come to mind. (1)Use a data validation rule that specifies that values >= 30 are the only valid values (you can disable all warnings in the data validation rule so it will allow entry of value

$$Excel-Macros$$ Excel Macro

Hi c Michael Cho -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 attention or

Re: $$Excel-Macros$$ How to creat circle on cells

How are you wanting this to happen? Are you wanting to make it so that it adds the circles automatically when the cell value changes? or are you wanting to run a macro (hit a button) and have it add the circles? Keep in mind that circles would be DRAWING OBJECTS and have no actual association wi

$$Excel-Macros$$ How to creat circle on cells

Dear Group, Kindly help me, i want to create Circles around the cells. means if i have some Numbers in any excel sheet and i want circle to be created on cell who have numbers less then 30. please help me. -- Pankaj Pandey Bhopal -- Join official Facebook page of this forum @ https://www.face

Re: $$Excel-Macros$$ Re: Find and the current data on Form

Thanks Ashish koul You were quick to answer, your answer is very good, sincerely thanks. 2012/12/18, ashish koul : > try this code for *ComboBox1_Change()* > > Private Sub ComboBox1_Change() > Dim rw As Long, cl As Range, found As Range > > Set found = Worksheets("ThamDinh").Range("A:A").Find(Me

Re: $$Excel-Macros$$ Re: Find and the current data on Form

try this code for *ComboBox1_Change()* Private Sub ComboBox1_Change() Dim rw As Long, cl As Range, found As Range Set found = Worksheets("ThamDinh").Range("A:A").Find(Me.ComboBox1.Value, LookIn:=xlValues) If Not found Is Nothing Then rw = found.Row tbxSoTT = Worksheets("Tham

Re: $$Excel-Macros$$ Re: Find and the current data on Form

try this code for *ComboBox1_Change()* Private Sub ComboBox1_Change() Dim rw As Long, cl As Range, found As Range Set found = Worksheets("ThamDinh").Range("A:A").Find(Me.ComboBox1.Value, LookIn:=xlValues) If Not found Is Nothing Then rw = found.Row tbxSoTT = Worksheets("Tham

RE: $$Excel-Macros$$ How to develop Addins

Dear Ashish, Thanks will check.. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 17 December 2012 22:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to develop Addins try these http://www.ozgri

Re: $$Excel-Macros$$ small query

*With formula* http://web.pdx.edu/~wde/Code/Excel_Files/No_VBA_Spellout.php VBA http://www.contextures.com/excelfilesRon.html#RF0001 http://support.microsoft.com/kb/213360 On Mon, Dec 17, 2012 at 1:20 PM, NOORAIN ANSARI wrote: > Dear Delin, > > Please see attached sheet with Excel an

Re: $$Excel-Macros$$ Consolidating Multiple files

hi *can you share the input file and final output file too* Regards Ashish On Mon, Dec 17, 2012 at 5:46 PM, SG wrote: > experts please help me with this.i have also attached the file . > > On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote: > >> hi Paul, >> >> Sorry for the inconvenie

Re: $$Excel-Macros$$ How to develop Addins

try these http://www.ozgrid.com/VBA/excel-add-in-create.htm http://www.rondebruin.nl/qat.htm http://www.rondebruin.nl/contextmenu.htm http://www.rondebruin.nl/qat2.htm On Mon, Dec 17, 2012 at 6:27 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Could you please help me unders

Re: $$Excel-Macros$$ Excel macro help please

can you share the sample file On Mon, Dec 17, 2012 at 9:57 PM, sw1085 wrote: > Hi all, > > I've been searching for hours looking for a generic macro to help with the > following problem. > > If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then > copy that cell plus the previ

$$Excel-Macros$$ Excel macro help please

Hi all, I've been searching for hours looking for a generic macro to help with the following problem. If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then copy that cell plus the previous 4 cells to a new worksheet called "Sheet2". Hope someone can help. Best regards sw10

Re: $$Excel-Macros$$ Merge entry cell

Even shorter than the previous one, =LOOKUP(10^10,E7:H7) Just type =10^10 in a cell for knowing the evaluated result. On 12/17/12, amar takale wrote: > Hi Dear, > > Solution is Perfect but waht is 10^10,I confused.I got Output but little > confusing. > > Thank Very much > > > On Mon, Dec 17, 201

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Hi Ashish, Thank you very much. Works fine, saved lot of time. Thanks. On Mon, Dec 17, 2012 at 7:11 PM, ashish koul wrote: > Sub add_comment() > Dim i As Long > Dim x As String, found As Range > Dim j As Long, k As Long > > For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row > Se

Re: $$Excel-Macros$$ To Add Comments based on Cell Value

Sub add_comment() Dim i As Long Dim x As String, found As Range Dim j As Long, k As Long For i = 2 To Sheets("Clients").Range("a1").End(xlDown).Row Set found = Sheets("Details").Range("a:a").Find(Sheets("Clients").Cells(i, 1).Value, LookIn:=xlValues) If Not found Is Nothing Then j

Re: $$Excel-Macros$$ Merge entry cell

Hi Amar, But Amar what about if there is number like : 2 ,2,3,4 then what should be the output for this. Regards Prince On Monday, December 17, 2012 6:32:12 PM UTC+5:30, amar takale wrote: > > Dear Noorain, > Actually I want Each column filled by different person & after finish data > entry I

Re: $$Excel-Macros$$ Help with INSTR

Hi, i put the link at the bottom of. my question. tx here is the link with the spreadsheet https://www.box.com/s/33z5kuabqbjn2b971ae6 matt -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Formula to Calculate Weeks

Thanks Paul. On 13 December 2012 18:30, Paul Schreiner wrote: > That is correct. > # (days) / 7 (days/week) = # (weeks) > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

Hi Paul, when are we seeing the rest of the calenders, is it possible to load it to say skydrive or any web hosting site and send us a link to download. thanks On Mon, Dec 17, 2012 at 3:07 PM, Paul Schreiner wrote: > [image: Boxbe] This message is eligible > f

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

I'll have to look at it and figure out how to calculate it differently. I'll get back to you soon.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you

$$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

As noted by Shreyas Gupta, it seems that Debaranan has submitted someone else's work as his own. I will speak with Ayush to determine how best to handle this situation. Paul On Thursday, December 13, 2012 2:11:20 PM UTC-5, Paul Schreiner wrote: > Results of the recent Calendar Challenge are I

Re: $$Excel-Macros$$ Calculate Business Hours exluding weekends and holidays with a caveat

That must be it! I think it's because your weekday formula "return_type" number (16) doesn't work in Excel 2007. I have the option of doing: 1 Returns a number from 1 (Sunday) to 7 (Saturday). 2 Returns a number from 1 (Monday) to 7 (Sunday). 3 Returns a number from 0 (Monday) to 6 (Sund

$$Excel-Macros$$ Regarding Result of Calendar Quiz.

Sir, I saw the calendar made by Mr. Debaranjan. The calendar is not made by Mr Debarajan himself it is downloaded from http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx and only modified by him. You can easily see the properties of the excel calendar made by Mr. D

$$Excel-Macros$$ To Add Comments based on Cell Value

Hi All, Good Afternoon!!! Can Somebody help me by giving a macro which can add comments based on a cell value like, In the attached workbook, sheet named 'Clients' I have a list of client codes against which 'Details' sheet they have some requirements in columns named 'Req.1' , 'Req.2', '

Re: $$Excel-Macros$$ Merge entry cell

Dear Noorain, Actually I want Each column filled by different person & after finish data entry I consolidated all column in one sheet then some of data entry is same in column but I want If same entry then show same one single unique number in K column.If more than two person input same numbers the

$$Excel-Macros$$ How to develop Addins

Dear Friends, Could you please help me understand how to write or develop Addin in Excel 2007? Do we have a training material or some write ups for hint? Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may a

Re: $$Excel-Macros$$ how to create formula in vba through cell references

Hi Swapnil I am not very good in VBA, can you please send me macro code for this. Regards Amit On Mon, Dec 17, 2012 at 5:54 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi, > > Try formula function of class Range > > Regards > Swapnil > On Dec 17, 2012 5:16 PM, "Amit Gandhi" w

Re: $$Excel-Macros$$ Merge entry cell

Dear Amar, Please explain your query and what is your exact requirment. On Mon, Dec 17, 2012 at 6:06 PM, amar takale wrote: > Hi All Experts, > Pls give any solution.I will try it bu not sucess > > > On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal wrote: > >> *Dear Amar,* >> * >> * >> *Pl share

Re: $$Excel-Macros$$ Merge entry cell

Hi Dear, Solution is Perfect but waht is 10^10,I confused.I got Output but little confusing. Thank Very much On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner wrote: > =LOOKUP(10^10,E7:H7,E7:H7) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Merge entry cell

Hi All Experts, Pls give any solution.I will try it bu not sucess On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal wrote: > *Dear Amar,* > * > * > *Pl share the test file.* > * > * > *Regards* > *Pravin Gunjal.* > * > * > On Fri, Dec 14, 2012 at 5:50 PM, amar takale wrote: > >> Dear Experts >> >>

Re: $$Excel-Macros$$ Consolidating Multiple files

experts please help me with this.i have also attached the file . On Monday, December 17, 2012 1:59:39 PM UTC+5:30, SG wrote: > hi Paul, > > Sorry for the inconvenience.PFA file & names of excel file are 1,2,3. > Please suggest. > > On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreine

$$Excel-Macros$$ how to create formula in vba through cell references

Hi Experts I need a macro which will fill-in mentioned formulas in cell C3 to K4 for sheet "backup" and get the desired results. activesheet.range("c2")= "=LOOKUP(2,1/(('*^BSESN*_WBQ'!$D:$D=$B3)*('*^BSESN* _WBQ'!$E:$E=C$2)),'*^BSESN*_WBQ'!$K:$K)" i need macro to get above red highlighted values

Re: $$Excel-Macros$$ Help with INSTR

Hi, i put the link at the bottom of my question. tx matt -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Ad

$$Excel-Macros$$ Re: Help Please

Why you want to have same name? On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote: > > Dear All, > > I'm inserting new sheet in a workbook but all sheet have a different name > like sheet1, sheet2. > > but i want, > > if I'm inserting new sheet then every time they have sam

Re: $$Excel-Macros$$ Merge entry cell

*In K7* =LOOKUP(10^10,E7:H7,E7:H7) *Non *Array Solution. On 14-12-2012 5:50 PM, amar takale wrote: Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012 at 1:00 PM, amar takale

$$Excel-Macros$$ Re: Merge entry cell

Good one Rajan Regards Prince On Monday, 17 December 2012 16:38:07 UTC+5:30, Rajan_Verma wrote: > > In K7 > > =INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0)) > > With CSE > > On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote: >> >> Dear all >> Can Anybody

$$Excel-Macros$$ Re: Help Please

No Possible with the same name On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote: > > Dear All, > > I'm inserting new sheet in a workbook but all sheet have a different name > like sheet1, sheet2. > > but i want, > > if I'm inserting new sheet then every time they have same

$$Excel-Macros$$ Re: Merge entry cell

In K7 =INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0)) With CSE On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote: > > Dear all > Can Anybody tell me formula to merge cell entry in one column if it is > duplicate then over right on it > > Regards > Amar

Re: $$Excel-Macros$$ Re: Macro enabled sheet to be worked with manual protect / unprotect

Dear Pravin, Could you please explain it more when you want to protect or unprotect the sheet. so that we can provide you best solution. Regards, Lalit Mohan On Monday, 17 December 2012 15:51:04 UTC+5:30, Pravin Gunjal wrote: > > Dear Prince > > Request for your co-operation on this issue. > >

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Swapnil, Fantastic, just what I needed. Thank you very much. Prince, thanks for your efforts, now sorted as you can see. Cheers, Ollyolly On Monday, December 17, 2012 9:02:21 AM UTC, ollyolly wrote: > I am looking to write a macro in excel. > I wish to position the cursor on worksh

Re: $$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi, Please find attached file for solution. In attached excel, macro is updating arrival time without copying it. And there is no key assigned to macro. When you enter value in A2 cell in Sheet1 and hit enter macro will update arrival time in Sheet2 Regards, Swapnil. On Mon, Dec 17, 2012 at 2:

$$Excel-Macros$$ Re: Plz help urgent

Try this also, =TRIM(REPLACE(A2, FIND(B2,A2),LEN(B2)+1,"")) Regards, Lalit Mohan On Monday, 17 December 2012 11:58:24 UTC+5:30, Anil Saxena wrote: > > Hi All, > plz help, I want correct email id and remove the bounce email from email > id column. > > -- > > *Anil Saxena* > > MIS Executive - R

$$Excel-Macros$$ Re: Extract value excluding 0

Hi karan Please Find one more way to do the same: =SMALL(($B$2:$B$6)*($B$2:$B$6<>0),COUNTIF($B$2:$B$6,"=0")+ROW(A1)) with Ctrl+shift+Enter Regards Prince On Monday, 17 December 2012 14:00:22 UTC+5:30, Karan Singh wrote: > > Dear All, > > I need your assistant to get value from the list exclud

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi ollyolly, That means the value in Cell A1 on Sheet1 is the arrival time, This time should be inserted into cell C1 on Sheet2 as you hit the enter Key on Sheet1 after typing entrants number in Cell A2 on Sheet1. Right ? Regards Prince On Monday, December 17, 2012 3:04:33 PM UTC+5:30, olly

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

> > Swapnil & Prince, > Thanks for your swift replies, I'll try and respond to you both in one post. The spreadsheet I am trying to write is to record the arrival time of event entrants at certain locations. Sheet 1 cell A1 contains the time function =now(). Sheet 1 cell A2 is where the entrants

Re: $$Excel-Macros$$ Help with INSTR

Matt, Please share your workbook. Regards, Anoop Sr. Developer On Sat, Dec 15, 2012 at 9:58 PM, Matt wrote: > Hi, search the forum but couldn't find an example that fit. I'm trying to > do a search off column "A" on the "Lookup" tab, and search for it in the > yellow column in the "2010Chase"

$$Excel-Macros$$ Re: Plz help urgent

Hi Anil, Please Paste this formula into C2 and drag upto C18 =REPLACE(A2,1,LEN(B2)+1,"") Regards Prince On Monday, December 17, 2012 11:58:24 AM UTC+5:30, Anil Saxena wrote: > > Hi All, > plz help, I want correct email id and remove the bounce email from email > id column. > > -- > > *Anil Sa

Re: $$Excel-Macros$$ Extract value excluding 0

Dear Pravin, Where are you facing problem with my formula. pls explain... On Mon, Dec 17, 2012 at 2:57 PM, Pravin Gunjal wrote: > Hi, > Ms-Excel has given the correct answer whereas Noorain's formula is not > working properly. > > Regards > Pravin Gunjal. > > -- Forwarded message -

Fwd: $$Excel-Macros$$

Here it's working. Thanks. -- Forwarded message -- From: NOORAIN ANSARI Date: Mon, Dec 17, 2012 at 2:04 PM Subject: Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Dear Karan, Please try =INDEX($B$2:$B$6,SMALL(IF($B$2:$B$6<>0,ROW($B$2:$B$6),""),ROW(A3))-1) with ctrl+s

$$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi Ollyolly, can you please tell us when this function will be performed. On opening of the workbook or on any other event. And one more thing where i will get the cell adress of the sheet 2 to put the cursor into Sheet2. Regards Prince On Monday, December 17, 2012 2:32:21 PM UTC+5:30, ollyo

Re: $$Excel-Macros$$ Reposition the cursor in an Excel macro

Hi, If you are inserting data automatically then no need to set cursor on sheet 2. Just define range object and assign value to it. If you provide sample data, it is easier to give solution. Regards Swapnil On Dec 17, 2012 2:32 PM, "ollyolly" wrote: > I am looking to write a macro in excel. >

$$Excel-Macros$$ Re: Extract value excluding 0

Hi Karan, Please paste this in C2 and Drag it down. =LARGE($B$2:$B$12,COUNTIF($B$2:$B$12,">0")+1-ROW(A1)) Regards Prince On Monday, December 17, 2012 2:00:22 PM UTC+5:30, Karan Singh wrote: > > Dear All, > > I need your assistant to get value from the list excluding 0. I'v > attached a sample

$$Excel-Macros$$ Reposition the cursor in an Excel macro

I am looking to write a macro in excel. I wish to position the cursor on worksheet 2 to automatically enter some data. The row number of the new position is dependant on the value of a cell in worksheet 1. Can anyone tell me how to do this? Thank you. -- Join official Facebook page of this for

Re: $$Excel-Macros$$

Dear Karan, Please try =INDEX($B$2:$B$6,SMALL(IF($B$2:$B$6<>0,ROW($B$2:$B$6),""),ROW(A3))-1) with ctrl+shift+Enter see attached sheet for more clarity. -- With Regards, Noorain Ansari http:// noorainansari.com http://

$$Excel-Macros$$ Re: small query

Hi rendils, Please apply this: * Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion "

Re: $$Excel-Macros$$ Consolidating Multiple files

hi Paul, Sorry for the inconvenience.PFA file & names of excel file are 1,2,3. Please suggest. On Friday, December 14, 2012 9:03:11 PM UTC+5:30, Paul Schreiner wrote: > I don't think we can work that way... > > You're using someone ELSE's macro with YOUR files and folders > and you've admit