$$Excel-Macros$$ Split Number into multiple cell

Hi Ashish, could you plese tell me the formula for Spliting number into multiple cell appriciate fi you have vba code but it shouold be dynamics 12345 like 1 2 3 4 5 in multiple columnsa -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread title

$$Excel-Macros$$ Opening All excel workbook one by one hen running the code

Hello Ashish, i need a help regarding the open all the excel file one by one and then running the macro. regarding macro i will take care so please suggest me any code for opening the all fiel please dont suggest application.file search becouse i m using 2010 as its wont work in that. i dont kno

Re: $$Excel-Macros$$ Excel auto filter using criteria from Combobox items

/*<http://noorain-ansari.blogspot.com/> > > > > On Wed, Oct 19, 2011 at 5:11 PM, ICWAI Help wrote: > > Hello everyone could anyone please let meknow the code for Excel auto > > filter using criteria from Combobox items > > i have 5 to 6 criteria from a combobox in

$$Excel-Macros$$ Excel auto filter using criteria from Combobox items

Hello everyone could anyone please let meknow the code for Excel auto filter using criteria from Combobox items i have 5 to 6 criteria from a combobox in form and i need to extract the data from excelsheet if any link that also apprciated. -- -

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

Hello, I have a pivot table which is dynamic which is going to be change every time when i open the workbook i want to get the unique value from pivot table field in combo box add item. lets example : my pivot table field is Agent name there are several agent who work repetedly till 4 rows

$$Excel-Macros$$ Get the Unique value from pivot table in combo box

Hello, I have a pivot table which is dynamic which is going to be change every time when i open the workbook i want to get the unique value from pivot table field in combo box add item. lets example : my pivot table field is Agent name there are several agent who work repetedly till 4 rows s

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

Sub > Range(Cells(tr, 2), Cells(tr, Target + 1)) _ > .Borders(xlEdgeBottom).LineStyle = xlContinuous > End Sub > > *From:* ICWAI Help > *Sent:* Tuesday, August 16, 2011 11:02 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ UDF Function for c

$$Excel-Macros$$ UDF Function for conditoin formetting

Please provide me UDF functino for below requirement example:) if the cell value is 4 then including active cell next 4 cell in a row should be higleted with color. ex if a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted. Thansk, Rakesh. -- -

Re: $$Excel-Macros$$ Any Group for MS access +Vb or simply Advance MS Acess

>> You can post in this group it self .Some one will resolve your query.. >> >> *Best Regards,* >> *Venkat* >> *Chennai* >> * >> * >> >> On Fri, Jul 29, 2011 at 3:46 PM, ICWAI Help wrote: >> >>> HI Members, >>> >>&g

Re: $$Excel-Macros$$ Date format

*right click on cell go to format go to custom format and then type as DD/MM/* *you will get it what you are expecting :)* ** On Fri, Jul 29, 2011 at 7:14 PM, Paul Schreiner wrote: > Does Excel recognize the dd-mm- as a valid DATE? > > That is: Can you change the format to "long date" fo

$$Excel-Macros$$ Any Group for MS access +Vb or simply Advance MS Acess

HI Members, is there Any Group for MS access +Vb or simply Advance MS Acess so i cant jion that group also as i have keen intreast in thsi too. Thanks. -- -- Some important links for excel users: 1. Follow us on TWI

$$Excel-Macros$$ Recover the VB password

HI Ashish, i have updated the VB password for my excel file while but i am not able to open now.could you please let me knwo is there any other way to open the codes.in that. Thansk, ICWAI. -- -- Some important lin

Re: $$Excel-Macros$$ Fwd: Query

HI hari for below Query you can just do as F1&G1&H1 as much as u can.. if you want to use anysyble between then just use as F1&"-"&H1. On Thu, Jul 28, 2011 at 6:49 PM, XLS S wrote: > Dear Hari, > > Use Concatenat Function or & operate..please find the attachment > > > > On Thu, Jul 28, 2011

Re: $$Excel-Macros$$ Custom function in Excel

Save you all UDF in madule in xlms file. you will get the help from excel editor. On Thu, Jul 28, 2011 at 5:09 PM, Venkat CV wrote: > Hi Sandeep, > > Save your UDF function as a .XLA (or)XLAM and you may open and use it... > > > > *Best Regards,* > *Venkat* > *Chennai* > On Thu, Jul 28, 2011

Re: $$Excel-Macros$$ Reverse Vlookup

Use Sumproduct function ti will help you. as manhy criteria you can put in brackets and get your desire result. *SUMPRODUCT(($B$3:$B$21=E3)*$A$3:$A$21)* On Thu, Jul 28, 2011 at 5:05 PM, Venkat CV wrote: > > Hi Anil, > > Look Attached it will help u... > > *Best Regards,* > *Venkat* > *Chennai* >

Re: $$Excel-Macros$$ Vba Code Required for Delete Entire Row

another way to delete simple just select the rows. simple macro to understand. *Sub deleterow() Application.ScreenUpdating = False Dim cell As Range Set cell = Selection For Each cell In Selection If cell.Value = 0 Then cell.EntireRow.Delete End If Next cell End Sub * On Thu, Jul 28, 2011 at 4:59

Re: $$Excel-Macros$$ need formula for find specif value based on multiple crteria

try sumproduct. SUMPRODUCT((A2:A31=A35)*(B2:B31=B35)*C2:C31) On Thu, Jul 28, 2011 at 11:57 AM, Venkat CV wrote: > Hi Mohan, > > If you want to get the data based on Multiple Criteria in 2007 You May Try > Countifs,Sumifs,Averageifs > > *Best Regards,* > *Venkat* > * > * > * > * > > On Thu, Jul

Re: $$Excel-Macros$$ use of indirect function

Oops there is no attachement at all any way thansk for help :) On Wed, Jul 27, 2011 at 7:11 PM, XLS S wrote: > Hey ICWAI, > > please find the attachment and try again with attachment > > > > > > On Wed, Jul 27, 2011 at 5:45 PM, ICWAI Help wrote: > >> Hi Noo

Re: $$Excel-Macros$$ use of indirect function

ATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) On Wed, Jul 27, 2011 at 9:23 AM, XLS S wrote: > Hey, > > please find the below mention link > > > http://www.jkp-ads.com/articles/ShowPicture00.asp > > > > > On Tue, Jul 26, 2011 at 5:32 PM, ICWAI Hel

Re: $$Excel-Macros$$ use of indirect function

Hi How the 3rd example sheet works or photo example sheet workds please explain clearly..:) On Tue, Jul 26, 2011 at 11:16 AM, sandeep chhajer wrote: > Dear Noorain, > > I have gone through your attachment and find it of a graet help. I hope you > wont mind to guide us in a *step by step* *action

Re: $$Excel-Macros$$ Help Required Urgent :)

gt; > Next i > ThisWorkbook.Sheets(4).Activate > > Application.ScreenUpdating = True > Application.DisplayAlerts = True > > End Sub > > > On Fri, Jul 8, 2011 at 3:49 AM, ICWAI Help wrote: > >> Hi Ashish, >> >> i have date in sheet its huge date i wan

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Hey Ashish heartly Congrats To you .. :) Thansk for everything Dear. On Tue, Jul 5, 2011 at 3:06 PM, simplyali wrote: > Thanks Ashish for the Invite.. I have accepted the same... > I would like to thank you million times for making me aware of this > post > > On Jul 5, 10:29 am, Kal xcel wr

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

OH Ashish, I havent gone throuh the mail. btw congrats buddy :) Thanks On Mon, Jul 4, 2011 at 10:07 PM, seraj alam wrote: > Hi Ashish, > > Many many congrats... > > > With best wishesh, > Seraj Alam > > > > > On Mon, Jul 4, 2011 at 9:40 PM, Hari wrote: > >> Thanks for getting the award. Even

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

evert me. > Regards > Pravesh Kumar > > On 7/5/11, ICWAI Help wrote: > > Search the employee name in Colomn B and get the email id and should be > > updated in Colomun C if any formula > > or code pelase give it to me I need to do with 1000 records even though > I >

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

USE indirect function ti will help you On Tue, Jul 5, 2011 at 2:25 PM, Rajan_Verma wrote: > *Try this* > > * * > > * * > > *Sub CompileSheet()* > > *Dim Sh As Worksheet* > > *Sheets.Add.Name = "Compile"* > > *For Each Sh In ActiveWorkbook.Sheets* > > *

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

you simply a champ On Tue, Jul 5, 2011 at 10:42 PM, ICWAI Help wrote: > thank you so much ashish its wrking now > On Tue, Jul 5, 2011 at 9:50 PM, ashish koul wrote: > >> try this >> >> >> On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote: >> >>>

Re: $$Excel-Macros$$ Two lookup value with sumproduct.

thank you so much ashish its wrking now On Tue, Jul 5, 2011 at 9:50 PM, ashish koul wrote: > try this > > > On Tue, Jul 5, 2011 at 7:54 PM, ICWAI Help wrote: > >> Hello Ashsih, >> >> COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION >&

$$Excel-Macros$$ Help Urgent Please

Search the employee name in Colomn B and get the email id and should be updated in Colomun C if any formula or code pelase give it to me I need to do with 1000 records even though I will match afterwords single single Note there wont be propper value or text u need to search with part of emplyee

$$Excel-Macros$$ Two lookup value with sumproduct.

Hello Ashsih, COULD YOU PLEASE EXPLAIN ME WITH TWO LOOKUP VALUE THE SUMPRODUCT FUNCTION ITS URGENT PLESE HELP ME AS SOON AS POSSIBEL. THANKS, RAKESH. -- -- Some important links for excel users: 1. Follow us on TWITT

Re: $$Excel-Macros$$ need required for data validation value query

Please find the attached file. Thanks, Rakesh. On Fri, Jul 1, 2011 at 5:49 PM, Markkim wrote: > I'm not sure if I understand what you want correctly. > > > O2 cell in your sample file > > you can have the following formula > > =VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0) > > t

Re: $$Excel-Macros$$ Pivot table - show pages as individual workbooks

Please attached the sheet or file we could help u then On Thu, Jun 30, 2011 at 9:50 PM, crossy75 wrote: > Hello again - and thanks for the last response, you guys are ace! > > right have now taken a lot of data relating to clients and have a > pivot table, which when i show pages lists 30 worksh

Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format

*="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,2)&"%"&""&"of the Plan)"* *find the attached file and formula it will works . * On Thu, Jun 30, 2011 at 5:58 PM, Monu Tiwari wrote: > Awesome . thanks everyone ! > > > On Thu, Jun 30, 2011 at 3:14 PM, ankur wrote: > >> hi ak >> file is attached f

Re: $$Excel-Macros$$ VBA Copy Comments Box (with photo)

Please attached the sheet. so we can help you better On Thu, Jun 30, 2011 at 6:29 AM, sswcharlie wrote: > Hi > > Have a photo in a comments box in wb 2. Also have a vlookup in > another workbook WB1 to bring forward the text from the cell into > WB2. This works great. I also want to bring fo

Re: $$Excel-Macros$$ Extract a comment and paste in adjacent cell

*Function GetComment(c As Range) GetComment = c.Comment.Text End Function * On Wed, Jun 29, 2011 at 11:52 AM, Vasant wrote: > Try this. > > Sub Test() > Dim Rng as range > Set Rng = ActiveSheet.Range("A1") > Debug.Print Rng.Comment.Text > End sub > > if you want to use it as a UDF > > Function G

Re: $$Excel-Macros$$ Extract only 10 digit mobile number

Hi Ashish, i have below code but i dont know whts the wrong with this. please chekc and guide me thansk for you continues help. Thanks, Rakesh. *Sub mobile() Dim i As Integer Dim strPath Dim strFile Dim UB For i = 1 To 400 strPath = Cells(i, 1) strFile = Split(strPath, ".") UB = UBound(strFile) S

Re: $$Excel-Macros$$ solution to put data automtically

HI Ashish , could you please attached the sheet with below formula how it works. Thansk, Rakesh. On Tue, Jun 21, 2011 at 8:35 AM, Subhash Yadav wrote: > Thanks a lot my friend > > > > On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote: > >> issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*R

Re: $$Excel-Macros$$ small doubt help me.

Can some one please provide the VB code or somehitng automationi for all this processure On Mon, Jun 20, 2011 at 5:16 PM, Vasant wrote: > use copy, and then paste special with transpose > > On Mon, Jun 20, 2011 at 3:46 PM, kannan excel wrote: > >> Hi Guru >> >> >> Pls help me i am waitin