Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

Thanks David. Will try to incorporate this into the macro. Cheers Ravi On 17 Dec 2017 7:20 am, "who" wrote: > Might try this too. Thanks, David > > Sub CopyPasteAll() > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues >

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Replace Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) with Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value, |) Kris On Tue, Oct 2, 2012 at 2:47 PM, Indrajit $nai talk2indra...@gmail.com wrote: @ Krishna, thanks a lot Sir, it's working fine

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

in this line it should be 3 .Range(b LastRow).Resize(, 3) in your code it's 4 Kris Kris ExcelFox -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

.Range(b LastRow).Resize(, 4) = Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value | Me.TextBox4.Value, |) Kris ExcelFox -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive =

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Remove any missing libraries via Tool References in the VBE window. Also keep red lines in single line rather than multiple lines Kris On Tue, Sep 25, 2012 at 7:12 PM, Indrajit $nai talk2indra...@gmail.com wrote: @Krishna, thanks for the solution, but one problem is there, when I'm using

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Provide a meaningful workbook. So that one could understand what's going on. Kris ExcelFox -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

Hi Put this code in Userform module. Dim wbkActive As Workbook Private Sub CommandButton1_Click() Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Shorter one. In D2 =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND(@,A2)),CHAR(160), ), ,REPT( ,99)),99))LEFT(MID(A2,FIND(@,A2)+1,255) ,FIND( ,MID(A2,FIND(@,A2)+1,255) )-1) In E2 =TRIM(SUBSTITUTE(A2,D2,)) Kris ExcelFox http://www.excelfox.com/forum/forum.php -- Join official facebook page of

Re: $$Excel-Macros$$ Date format change by running the macro

Hi Select the range and run this macro Sub kTest() Dim x With Selection x = .Address .Value = Evaluate(if(isnumber( x ),TEXT( x ,\-00\-00)+0, x )) .NumberFormat = dd-mmm- End With End Sub Kris ExcelFox http://www.excelfox.com/forum/forum.php --

Re: $$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

Hi BTW, you said there is only two products. So how Z comes in the list ? Anyway, try =IF(COUNTIFS($A$1:$A$6,x,$B$1:$B$6,B1)*COUNTIFS($A$1:$A$6,y,$B$1:$B$6,B1),Closed,Open) Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

I hate loops :( Sub kTest() Dim r As Long With Range(b2:b Range(a Rows.Count).End(3).Row) r = .Rows.Count + .Row - 1 .FormulaR1C1 = =index(r2c[3]:r r c[3],match(rc[-1],r2c[4]:r r c[4],0)) .Value = .Value End With End Sub Kris ExcelFox

Re: $$Excel-Macros$$ Top Three

Hi In G1: 3 In H2 and copied down, =IF(ROWS(H$2:H2)=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),) In I2 and copied down, =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1),COUNTIF($H$2:H2,H2))),) It's an array formula. Confirmed with CTRL + SHIFT + ENTER Kris ExcelFox

Re: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files

Hi Couple of links you may find useful http://www.excelfox.com/forum/f12/split-unique-data-into-multiple-workbooks-33/ http://www.excelfox.com/forum/f2/split-data-into-multiple-workbooks-3-conditions-393/ Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Need Help on Formulas

Hi Try =LOOKUP(2,1/(({High;High;High;Medium;Medium;Medium;Low;Low;Low}=F5)*({High;Medium;Low;High;Medium;Low;High;Medium;Low}=G5)),{1;2;1;1;2;3;1;3;3}) replace F5 and G5 with Frequency and Probability respectively. Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Hi Try this Sub kTest() Dim ka, k(), i As Long, c As Long, n As Long, Hdr, x Dim wks As Worksheet, Flds Hdr = Array(NAME, Specialty_name, Office_name, Address_1, Address_2, _ Address, Phone_number_1, Fax_number) ka =

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

John You are welcome. Thanks for the feedback Kris ExcelFox http://www.excelfox.com/forum/forum.php -- 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

Re: $$Excel-Macros$$ Macro To Transpose Selected Row Data To Column Format

Replace ReDim k(1 To UBound(ka, 1) * (UBound(Hdr) + 1) + UBound(Hdr) + 1, 1 To 1) with ReDim k(1 To 1, 1 To 1) Kris ExcelFox http://www.excelfox.com/forum/forum.php -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ How to protect cells or formulas in excel sheets

Hi Veeru, Could you send us the excel sheet. On 2/8/12, Veeru TOC veerub...@gmail.com wrote: Dear Team in excel file i know protect sheets but i need particular Cells put the code or protect how it possible VBA code also no problem -- *ThanksRegards* * * *

Re: $$Excel-Macros$$ Next Working date

Hi Srinivas, You can try this formula: =IF(WEEKDAY($A$1)=7,A1+DAY(2),IF(WEEKDAY($A$1)=6,A1+DAY(3),A1+DAY(1))) On 2/9/12, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Group, Please suggest any formula to pick next working date, but Saturday and Sunday should not include.

Re: $$Excel-Macros$$ Add to this group

an invite just now. Please check the link Regards, Sam Mathai Chacko On Tue, Feb 7, 2012 at 10:26 PM, Krishna madolli kmado...@gmail.comwrote: Hi my friend want to add his ID to this group, please let us know the procedure -- Krishnaraddi V Madolli. -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

Dear Kiran, Use =upper(cell reference) Sent from my iPhone On 10-Nov-2011, at 9:00 PM, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ vadnalaki...@gmail.com wrote: Hi Anybody can help me out how to make small letter to capital letter in Ms excel V.Kiran -- FORUM RULES (934+

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On Tue, Aug 2, 2011 at 5:25 AM, Sam K soura...@gmail.com wrote: give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel sheets

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

vijaykumar and venkat thank you very much for your valuable input. On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

...Reports generation Data Management activities *Best Regards,* *Venkat* *Chennai* On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Thank you very much sir, Really very detailed explanation. Once again Thank you very much. On Tue, Jul 26, 2011 at 4:28 PM, anandydr ananad...@gmail.com wrote: Hi, In case of MIS Executives the kind of the data sets is very rigid. The data is always in the same format. Mostly the amount of

$$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my

Re: $$Excel-Macros$$ Fwd: Data Chart

Hi Kumar, Frankly, the dataset you have, coal accounts for 90% of the total cost..thats the reason you will see only effect of coal. I think considering two charts one with coal vs total cost and the other excluding coal. Krishna On Fri, Apr 8, 2011 at 5:42 AM, C.G.Kumar kumar.bemlmum

Re: $$Excel-Macros$$ discussexcel.com Launched today

/discussexcel -- Regards, Krishna -- -- 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 @ http://www.linkedin.com

Re: $$Excel-Macros$$ Delete rows including blank row except few members

:07 AM, Hari Lal. C harilal@gmail.com wrote: HLC Dear Krishna Mummina, I saw yr solution to the question of Niel Johnson. As i am a primary student in Excel I don't know how to create Excel Macro. I would like to know how to apply these commands in excel and how to use it. Shall I

Re: $$Excel-Macros$$ Delete rows including blank row except few members

Try this: It will delete the entire row when specification meets Sub processdata() Dim i As Long, lr As Long lr = ActiveSheet.UsedRange.Rows.Count Application.ScreenUpdating = False For i = 1 To lr If Range(A i).Value = Then Range(A i).EntireRow.Delete If UCase(Range(A i).Value) =

Re: $$Excel-Macros$$ vba to notepad

Dear Vijaykumar, Do you mean, an is inserted for all the data? Can you please illustrate by an example? Thanks, Krishna On Oct 18, 2:04 am, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear krishna, It is possible to copy the contents of Excel to note pad.But, the only problem is the pasted

Re: $$Excel-Macros$$ help required

Dear Girish, Sorry I didn't understand what you are looking for, Please give an Example, what you want exactly? May be i have some communication problem to understand your query. Thanks, Excelkid On Mon, Oct 18, 2010 at 7:52 PM, girish kumar girishkumar832...@gmail.comwrote: Dear Experts,

$$Excel-Macros$$ vba to notepad

How can we copy the contents from excel to notepad. For instance the range of cells A1:B5 to notepad? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Password Help Required

Hi, what about a hidden sheet? On Mon, Oct 11, 2010 at 11:23 PM, hemant shah hemanthin...@gmail.comwrote: Hi All, Can you please help me with my query regarding the password change in VBA. Thanks in advance. Waiting for the resolution on my query. Regards, Hemant Shah --

Re: $$Excel-Macros$$ Rupee symbol HOW ???

Check out here: http://bishwajeet.blogspot.com/2010/07/steps-to-include-indian-rupee-symbol.html On Sat, Oct 9, 2010 at 3:17 PM, SAJID MEMON sajidwi...@hotmail.com wrote: -- Hi, I have done following tricks but not satisfied as : 1) Select the column/cell

$$Excel-Macros$$ HELP

Hi Guys, I am running a variance between two numbers and am unable to get the proper condition required. In the file attached in Clmn E it is working correct if there are numbers in Clmn B. But if B is zero then the formula should show a red arrow (if there is a number in Clmn A) Hope

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

Hey Dude, Do this, Select the Cell which you want to delete and Ctrl+Select Every Sheet, then press Delete. I hope it will helpful. Regards, Krrish On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla sudheer1...@gmail.com wrote: Hi guys I Have a column xyz which is there in every sheet of the

Re: $$Excel-Macros$$ How to delete blank columns rows using VBA

Hey, Check this and Let me know. Sub del_br() Dim coun As Long With ActiveSheet For coun = .Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1 If WorksheetFunction.CountA(.Rows(coun)) = 0 Then ActiveSheet.Rows(coun).Delete End If Next End

$$Excel-Macros$$ VBA CODE UNLOCKER

Hello Guys, Check it out. http://www.vbaunlocker.info/* * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Help in sending the salary slip

You may use of macro. I am not sure about Password for the file, but You can send automatically to the Concerned person. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

Congratulations Ayush Jain. Really Very proud of you man. On 10/4/10, rajasekhar praharaju rajasekhar.prahar...@gmail.com wrote: hearty congratulations ayush, you really deserve it Infact you are good encyclopedia for us. Have a flamboyant future and delightful moments for ur

$$Excel-Macros$$ Excel Related Jobs

Hello All, My name is krishna, Currently working as a Data Analyst based on Excel. So, I want to know the Other Areas where we can Get the Job. Basically I have 2 years of MNC Experience as a Data Analyst, and I am a Excel Advance User. I am looking to give a try in Deloite and Other Big daddy's

Re: $$Excel-Macros$$ Fwd:

Hi praveen, we can find the position and could you please tell me why you need it. Bye On 7/2/10, praveen kumar bhspra...@gmail.com wrote: Hi Friends, Is there any way to find the position of the space in a word from right side. Ex: United States of America - here the position of the

Re: $$Excel-Macros$$ How to increase size and color of text in user form ?

CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT. On 7/2/10, worawat kh worawat...@gmail.com wrote: Dear Group , How to increase size and color of text in user form ? Thanks, Worawat --

$$Excel-Macros$$ Re: Need Help....!

Hi.. Thank you very much. You've helped me greatly.. I am really delighted. Thanks a lot. Wish you all the very best in your life. Take care Bye http://smsxite.com/picdetail.php?catId=43tid=39 Krishna Kishore http://smsxite.com/picdetail.php?catId=43tid=39 Friendship SMS

$$Excel-Macros$$ Re: Need Help....!

Hi.. Yes. This helped me a lot. This was exactly what I was looking for. Thank you very much. Have a great weekend. Take care Bye http://smsxite.com/picdetail.php?catId=43tid=39 Krishna Kishore http://smsxite.com/picdetail.php?catId=43tid=39 Friendship SMS _ From: excel