$$Excel-Macros$$ Re: Need help on conditional formating

Please help... On Monday, September 24, 2018 at 5:31:49 PM UTC+5:30, vikas khen wrote: > > Hi All, > > > > Kindly find the attached two sheets, based on the same I need Conditional > formatting formula to highlight the cell value in color it the given > criteria matches. I have mentioned the

Re: $$Excel-Macros$$ Re: Need Help in IF formula

Put the below formula in D1. =IF(A1>B1,"Buy","Sell") Since you have only two checks to be done, no need of nesting loop here. ( i mean if within if). Thanks & Regards, Prabhu R On 17 February 2018 at 06:08, who wrote: > Maybe this will work for you? >

$$Excel-Macros$$ Re: Need Help in IF formula

Maybe this will work for you? =IF(A1>B1,"Buy1",IF(A1 I have a table where data changes continously (stock market data). I want > to apply IF formula. please understand with given example.

Re: $$Excel-Macros$$ Re: Need Help in IF formula

the formula seems to work as it is designed.So what kind of help do you need?  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 can, As long as ever

$$Excel-Macros$$ Re: Need Help in IF formula

-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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,

$$Excel-Macros$$ Re: Need help in Vba Macro

Hi Paul, I am getting error message mentioning the cells cannot be pasted as the size and shape is not same. Regards, Kaushik On Tuesday, May 23, 2017 at 11:32:58 PM UTC+5:30, KAUSHIK SAVLA wrote: > > Hi Team, > > I am trying to do below in an excel. You can assume there are 60 > worksheets

$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Thanks *Suresh.* It's working as required... :) On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote: > > Dear Experts, > > Please help to resolve below requirement. > > File attached for reference. > > > *Numbers .: 1,054,265* > > *Result Shows .: *Ten Lakh Fifty Four

$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Hi *Sachin*, As you said, I have made changes in the file through formulas Please check & let me know, If any Changes. *Thanks & Regards,* *Suresh Kumar.B* *Mobile #9894585740* On Friday, February 17, 2017 at 10:53:19 AM UTC+5:30, सचिन शर्मा wrote: > > Thanks Suresh, > > It's working and

$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Thanks Suresh, It's working and shows "*and*" before last 2 "00" digits. but, if value comes less then 100 then "*Hundred And*" still visible (Ex.: 99 = *Hundred and Ninety Nine Rupees Only*) On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote: > > Dear Experts, > > Please

$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text

Dear Sachin, Herewith i have attached the completed file as you requested. Please Check & let me know, If you have any questions. Thanks, Suresh Kumar.B Mobile # 9894585740 On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote: > > Dear Experts, > > Please help to resolve

$$Excel-Macros$$ Re: Need help on Arrey Formula

This might help brother =SUM(TRANSPOSE($C$2:$F$2)*$L$2:$L$5) ctr+shift+enter regards Abhinav On Friday, December 2, 2016 at 11:35:36 AM UTC+5:30, Deepak Rawat wrote: > > Hi, > > I need to calculate final billing product of several product with > respective MRP. > > sample file is attached. > >

Re: $$Excel-Macros$$ Re: Need help in macro

Yes, its working for me, can you please share the screenshot. thanks -- On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi wrote: > Was it working fine for you? i am getting error in the below two line > (error #1044) so, Else part "Range("b2").Validation.Delete" is not >

Re: $$Excel-Macros$$ Re: Need help in macro

Was it working fine for you? i am getting error in the below two line (error #1044) so, Else part "Range("b2").Validation.Delete" is not working. .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween,

Re: $$Excel-Macros$$ Re: Need help in macro

Try enclosed one. -- On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi wrote: > Thank you so much. This helped me a lot:-) > > Is there any option to disappear the dropdown when user does not have any > value in column B. instead of disable the drop down in the column B. >

$$Excel-Macros$$ Re: Need help in macro

Thank you so much. This helped me a lot:-) Is there any option to disappear the dropdown when user does not have any value in column B. instead of disable the drop down in the column B. once again Thanks a lot :-) Keerthi On Saturday, August 27, 2016 at 11:33:50 AM UTC+5:30, Manju Keerthi

$$Excel-Macros$$ Re: need help with Evaluate function

Share your sheet otherwise its not possible what the other variables holds Position ?? Player ?? Regards :- Mandeep baluja 'https://www.facebook.com/groups/825221420889809/ 'https://www.linkedin.com/in/mandeep-baluja-b777bb88 On Friday, May 13, 2016 at 7:28:01 AM UTC+5:30, Jaime Richmond

Re: $$Excel-Macros$$ Re: Need help

can you send me a sample file directly?That way I can try out some things without spending hours building a test file that doesn't look anything at all like what you have! You can send it directly to:schreiner_p...@att.net  Paul- “Do all the good you can,

Re: $$Excel-Macros$$ Re: Need help

Yes, can you pls suggest the alternative code. Idea is when comboboxes are empty then it should run only on dates. Cheers Karthik On Tuesday, 29 March 2016 20:01:03 UTC+5:30, Paul Schreiner wrote: > > Ah... > I think maybe we should rethink the logic here. > In your statement: > Set rngD =

Re: $$Excel-Macros$$ Re: Need help

 Ah... I think maybe we should rethink the logic here.In your statement:Set rngD = wshD.Range("G:G").Find(What:=Me.ComboBox1.Value, Lookat:=xlWhole)if Me.ComboBox1.Value is empty, you're looking in column G for "nothing".Does the .Find method return an empty range? or a range of which column G

$$Excel-Macros$$ Re: Need help

Thanks Paul for your response.Here is the complete macro for better understanding. Sub Fetch_Click() Dim wshD As Worksheet Dim wshP As Worksheet Dim rngD As Range Dim rngP As Range Dim r As Long Dim m As Long Dim n As Integer Dim rngD2 As Range

$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

Hi Maju,,,i think if you provide some example sheet, you will get your answer very soon. On Wednesday, March 9, 2016 at 8:23:53 PM UTC+5:30, Maju wrote: > > Hello all! > > > > Please I need macro help with the below in red: > > What is the best way to achieve this without using the

$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

I came up with below but I need a better efficient way of writing it. I don't think it is the right way to do for each statement all the time. Dim CurCell As Object Dim CurCell2 As Object Dim CurCell3 As Object Dim CurCell4 As Object Dim

$$Excel-Macros$$ Re: Need Help

Sub Solution() Range("A7").Select Do Until IsEmpty(ActiveCell) ActiveCell.Copy ActiveCell.Offset(0, 1).Select ActiveCell.PasteSpecial xlPasteAll ActiveCell.NumberFormat = "MMM-YY" ActiveCell.Offset(1, -1).Select Loop End Sub On Sunday, January 10, 2016 at 8:51:53 PM UTC+5:30, Pankaj Sharma

$$Excel-Macros$$ Re: Need Help in calculation of score

Hi Mandeep, Sorry for the confusion. Final score is 100 if all are Yes. I need the formula in Colum "I" for Score.(Distribution of Score in case of "NA" should be calculated here.) Data in K:P are the values for "Yes" & "No" of data in B:H. PFA updated sheet. The difference in headers are typo

$$Excel-Macros$$ Re: Need Help in calculation of score

> > Hey check this out !! >> > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Re: Need Help in calculation of score

Hi Mandeep, Please refer to the comment in attached sheet. I hope it would get clear now. :) On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote: > > Hey SG, > > Correct me if I am wrong !! > 1)If Parameter M(Fatal) is No, then total score would be 0 Formula should > be

$$Excel-Macros$$ Re: Need Help in calculation of score

Hey SG, It's very difficult to understand your query what you wish or what you want to achieve as may be we both are using different terminology or might be explanation. Sorry to say Hope someone will help you with these given below instructions as I am not able to matchup the aim. You

$$Excel-Macros$$ Re: Need Help in Macro Loop for data dirstribution

> > Check this out,Easily achieved with formula > {=IFERROR(INDEX(Raw!$D$2:$H$85,MATCH('WAVE 1'!$A4&'WAVE 1'!B$2&'WAVE > 1'!$A$2,Raw!$A$2:$A$85!$B$2:$B$85!$C$2:$C$85,0),MATCH(B$3,Raw!$D$1:$H$1,0)),0)} > Regards, Mandeep baluja -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ Re: Need help to split numbers available in the last

Thanx a lot mandeep its working. On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote: Hi, Please help me out to split numbers from a cells if the numbers available in the last then. Example attached. Thanks. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Re: Need help to split numbers available in the last

;) Glad to help https://www.facebook.com/groups/825221420889809/ On Thursday, August 6, 2015 at 11:55:00 AM UTC+5:30, Nasir Saikh wrote: Thanx a lot mandeep its working. On Wednesday, August 5, 2015 at 1:05:03 PM UTC+5:30, Nasir Saikh wrote: Hi, Please help me out to split numbers from

$$Excel-Macros$$ Re: Need Help on OFFSET MATCH formula

What is the criteria for the best price Is it the min value from the price column against a particular Item.?? Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Monday, June 1, 2015 at

Re: $$Excel-Macros$$ Re: Need Help on OFFSET MATCH formula

Yes, Minimum Value On Mon, Jun 1, 2015 at 12:12 PM, Mandeep Baluja rockerna...@gmail.com wrote: What is the criteria for the best price Is it the min value from the price column against a particular Item.?? Regards, MandeepBaluja Learningzmypassion.

$$Excel-Macros$$ Re: Need Help on OFFSET MATCH formula

Check this attachment !! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Monday, June 1, 2015 at 10:07:52 AM UTC+5:30, TAWHID wrote: Dear Experts, Need little help here. Please have a look

$$Excel-Macros$$ Re: Need help to print only certain no of records from a payroll of employees

Dear Vabz! I can't find your last email. Plz send me your suggestion in this post. I'll be thankful to your Thanks On Friday, December 26, 2014 11:19:38 PM UTC+5, MRafique Ujjan wrote: Dear Experts! I am facing problem during printing of payroll because it consists more than 1000

$$Excel-Macros$$ Re: Need help to create a user form.

Hello kamal, check dis out . Private Sub CommandButton1_Click() Dim brand As Long Dim invoice As Long Dim cell As Range brand = TextBox1.Value invoice = TextBox2.Value temp = brand invoice Set ws1 = ActiveWorkbook.Sheets(1) For Each cell In ws1.Range(a1, [a65535].End(xlUp)) If

$$Excel-Macros$$ Re: Need Help with the macro file

Yes there is option in excel to split the data in seperate column as same format of pdf . On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote: Hello , I need your help with regards to the attached macro file. I am trying to convert the pdf file to excel format but the

$$Excel-Macros$$ Re: Need Help with the macro file

Hello , Awaiting for your help !. Thanks, Ujjwal On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote: Hello , I need your help with regards to the attached macro file. I am trying to convert the pdf file to excel format but the conversion is not as expected.

$$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

Sorry I'm an excel noob, I don't understand what to do. On a side note though, i was wondering what the formula would be if it was just to find whether Cells(1, 1).Value exists in row B, and where it would be. Also what would the formula for selecting the bottom row with a value in it be?

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

Hi You need to use count if formula to get what you want..in range you need to specify both the column where probable value would be. Refer file in my previous post with yellow colored range. Cheers!! On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii koukinom...@gmail.com wrote: Sorry I'm an

$$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

Hi, thanks for the help. However, this only seems to work with the set of values I provided as an example. i was wondering if there is a way it would work with any set of numbers I add to the A column. Thanks On Sunday, June 15, 2014 2:09:39 AM UTC+9, Noah Shalii wrote: Hi, I am in need of

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

Hi Check yellow cells.. Cheers!! On Sun, Jun 15, 2014 at 11:05 AM, Noah Shalii koukinom...@gmail.com wrote: Hi, thanks for the help. However, this only seems to work with the set of values I provided as an example. i was wondering if there is a way it would work with any set of numbers I

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hi Suyog Kulkarni, See how build an Excel Add -In http://www.fontstuff.com/vba/vbatut03.htm Regards, Basole 2014-04-05 1:22 GMT-03:00 Suyog Kulkarni nashi...@gmail.com: Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is

$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hi, try this: x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select Regards, Basole. 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni nashi...@gmail.com: Hello All, I made my first macro code. Kindly review. Now only

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned ctrl+q shortcut which is not working now 2. How can we save the code as Add In or can we add any buttom in existing toolbar ? so I that I can share the same with my co-workers.

$$Excel-Macros$$ Re: Need Help with VBA in Excel

PG, Please share an example with some data! regards, Basole. Em sexta-feira, 20 de dezembro de 2013 16h27min17s UTC-2, PG escreveu: Hi, I have a problem to solve here. I have a master list of about 1000 records, which has Order ID, Customer Name, Address, and Order Amount columns.

$$Excel-Macros$$ Re: Need help

Hello Philip, I think this is not an appropriate environment to request this kind of help! regards, Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu: Hope you get this on time, I made a trip to Ireland and my Bag was stolen from me with my passport, cash and

RE: $$Excel-Macros$$ Re: Need help

$$ Re: Need help Hello Philip, I think this is not an appropriate environment to request this kind of help! regards, Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu: Hope you get this on time, I made a trip to Ireland and my Bag was stolen from me with my

$$Excel-Macros$$ Re: Need help to convert Txt to Excel

Hi Jocky, try this option in VBA. Sub ImportTXT() Dim DateTime As String '7 to 29 Dim CardHolder As String ' 33 to 49 Dim DoorZone As String ' 55 to 83 Dim Status As String ' 93 to 103 Dim nFile, rowTxt As String nFile = C:\temp\1234.txt 'change according to the way of your TXT

$$Excel-Macros$$ Re: Need help in forecast

Hi Prabhu, I can help you if you can share data with me... On Wednesday, September 18, 2013 8:59:41 AM UTC+5:30, prabhupink80 wrote: Hi Experts, i have historical pattern of last few month daywise daily offered. is there possible to calculate the next month overall volume by using excel.

$$Excel-Macros$$ Re: Need Help with Lookup function involving NFL scores

On Monday, July 15, 2013 10:03:35 PM UTC-4, bobsc...@yahoo.com wrote: Hello, I am using Excel 2003. I have attached a simple workbook which has two worksheets. One worksheet is titled Scores and the other is Team Info. On the team info worksheet, I have all the nfl teams listed in

$$Excel-Macros$$ Re: Need help on worksheet protect and unprotect code

Hi, The following features can't be changed after a workbook is shared: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable reports, workbook and worksheet protection, and

$$Excel-Macros$$ Re: Need help on worksheet protect and unprotect code

If you want to use VBA on a shared workbook I would recommend moveing the code to an XLA On Friday, June 7, 2013 10:45:10 PM UTC+5:30, maksood alam wrote: Hi Guys, I have workbook with codeing below Private Sub Worksheet_Change(ByVal Target As Range) *Sheets(MMPs).Unprotect 1234*

RE: $$Excel-Macros$$ Re: Need help on worksheet protect and unprotect code

HiJust active macro and click to protect the sheet and unprotect the sheet and see the macro, you will get the VBA code of your require.thanx Date: Sun, 9 Jun 2013 00:15:38 -0700 From: v...@vabs.in To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help on worksheet protect

$$Excel-Macros$$ Re: Need help using Modules in Excel 2007

On Wednesday, March 27, 2013 9:30:05 AM UTC-6, gka...@gkading.com wrote: I've created a simple module in excel 2007: Function Sigmoid(t) Sigmoid=1/(1+exp(-t)) End Function The sigmoid function seems to work in formulas initially, but when file is saved, closed, then reopened, the

$$Excel-Macros$$ Re: Need help using Modules in Excel 2007

Just try to replace your function with following. public Function Sigmoid(t) as double Sigmoid=1/(1+exp(-t)) End Function regards prince On Thursday, March 28, 2013 4:37:23 AM UTC+5:30, gka...@gkading.com wrote: On Wednesday, March 27, 2013 9:30:05 AM UTC-6, gka...@gkading.com wrote: I've

$$Excel-Macros$$ Re: Need Help for formula

Hi jocky Beta, Please paste the this formula in Cell C6 With Ctrl+Shift+Enter =IF(AND(($B$6=$A$13),SUM((C$4=$D$4:$H$4)*1)),$B$13,$B$14) and C7 =IF(AND(($B$7=$A$15),SUM((C$4=$D$4:$H$4)*1)),$B$14,$B$13) with CSE Regards Prince On Friday, January 4, 2013 4:59:03 PM UTC+5:30, jocky Beta wrote:

$$Excel-Macros$$ Re: Need help

Hi Karthik, I ]need some clarification about your queries. 1. As you have mentioned all the details, Do you want any macro that extract all these details as you have listed into sheet. Or do you want any excel formula or macro that extract summary from your data that is in sheet it self.

$$Excel-Macros$$ Re: Need Help for Access 2007- How to remove unwanted characters from table.

Hi Mangesh, Can you plase share your workbook with us ? Regards Prince On Friday, November 9, 2012 12:09:18 AM UTC+5:30, Mangesh wrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when

$$Excel-Macros$$ Re: Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

fantastic Paul. yes, all workbooks in only one folder. worked like a charm. Many thanks. Mel On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote: I have a master spreadsheet with 5 tabs. On my master sheet (called Master) - on the tab called 'Option Letter' I need to copy

$$Excel-Macros$$ Re: Need Help in allocation table

Hi Can you explain base for allocation, theer is no standard method that can be assumed on the basisi if data given by you. Rgds//Vabs On Thursday, October 4, 2012 12:03:22 PM UTC+5:30, Vishwanath wrote: Need help Dear All, I need your help in automatic some calculations in

$$Excel-Macros$$ Re: Need Help in allocation table

Always show a before/after and the logic On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote: Need help Dear All, I need your help in automatic some calculations in spreadsheet. I have data in excel as below; It consists of 2 parts. first part is Expense statement and

Re: $$Excel-Macros$$ Re: Need Help in allocation table

Dear wabs, Thanks for your reply. The amount should be allocated equally over the period of time. For example, for expenditure B, total expenditure of Rs. 1 has been distributed prorata basis. It works out 3667 for 22 days in April, 5000 for may(full month) and 1333 for for June . The period

Re: $$Excel-Macros$$ Re: Need Help in allocation table

can you attach the sample sheet On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath vishwana...@gmail.com wrote: Dear wabs, Thanks for your reply. The amount should be allocated equally over the period of time. For example, for expenditure B, total expenditure of Rs. 1 has been distributed

Re: $$Excel-Macros$$ Re: Need Help in allocation table

Dear Ashishi, Sending the the sample file. thanks in advance for your cooperation. On 8 October 2012 21:55, ashish koul koul.ash...@gmail.com wrote: can you attach the sample sheet On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath vishwana...@gmail.com wrote: Dear wabs, Thanks for your reply.

$$Excel-Macros$$ Re: Need help

Hi Karthik, Pls see the attachment. regards Prince. On Thursday, October 4, 2012 7:14:56 PM UTC+5:30, karthik n wrote: Hi Team, Please help in the attachment file Regards karthik.N -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

$$Excel-Macros$$ Re: Need help

Array Formula =IFERROR(SMALL(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),ROW(INDIRECT(1:COUNT(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),) g is your list name. Rajan On Thursday, 4 October 2012 19:14:56

$$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Hi Please refer link for details: Link http://www.ozgrid.com/Excel/autocomplete-validation.htm Rgds//Vabs On Tuesday, September 25, 2012 3:24:58 PM UTC+5:30, Manoj Kumar wrote: Hi, Is there an way to autocomplete the words from the custom list. When someone type the first word, the word

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Not able to understand clearly. can you please the solution in the attached file. On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote: Hi Please refer link for details: Link http://www.ozgrid.com/Excel/autocomplete-validation.htm Rgds//Vabs On Tuesday, September 25, 2012 3:24:58

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use Data Validation. It will not give you auto complete option. It will give you dropdown for cell and user have to select value from drop down. Regards, Swapnil. On Tue, Sep

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Thnks for reply. The validation list need to be updated in regular basis and also i have very long list and also can not hide too much rows in the sheet. Is there any VBA solution for this? I am looking for quite a long time and but didnot manage to get it. On Tue, Sep 25, 2012 at 5:40 PM,

RE: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

-Macros$$ Re: Need Help in AutoComplete with Custom List Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use Data Validation. It will not give you auto complete option. It will give you dropdown for cell and user have

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List ** ** Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use Data Validation. It will not give you auto

$$Excel-Macros$$ Re: Need help - To divide the string into three parts

Hi Mangesh, Try this hope tghis will help you. =TRIM(MID(SUBSTITUTE($A$1,,,REPT( ,LEN($A$1))),((COLUMNS($A$1:A1)-1)*LEN($A$1))+1,LEN($A$1))) paste this in B2 then press f2 select B2 to D2 and CSE regards Prince On Monday, September 10, 2012 4:34:33 PM UTC+5:30, Mangesh wrote: Hi

$$Excel-Macros$$ Re: Need Help

Hello Khan, Please check the file attached , hope it helps. On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0,

Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I

Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so

RE: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

That’s not possible Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay Sent: 28 June 2012 8:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need

RE: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

Sent: Thursday, June 28, 2012 8:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using

$$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet

Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote:

$$Excel-Macros$$ Re: need help on maximum value and thier name

Hi Sunita, For finding max value with name you can apply this formula, Hope this will work for you. =INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),1) : INDEX($A$1:$B$14,MATCH(MAX($B$1:$B$14),$B$1:$B$14,0),2) regards prince On Monday, 25 June 2012 12:13:04 UTC+5:30, suneeta wrote:

$$Excel-Macros$$ Re: Need help in ranking with multiple criteria

Hello Vijay. PFA. On Tuesday, April 24, 2012 8:31:29 AM UTC+3, Vijay Mane wrote: Hi Experts, Please refer file for more information I want to calculate top performer agent according to achieved target and quality If there are multiple agent with same achieved target and quality

$$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using column names for looping

Asa, I tried what you said but am doing something wrong. First when I used the exact same string as both the Set variable and the Match variable it said it needed an object. It did not like identical names I guess? Then I created different object names and that would compile but I have tried

RE: $$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using column names for looping

@googlegroups.com] On Behalf Of tangledweb Sent: Thursday, March 22, 2012 12:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using column names for looping Asa, I tried what you said but am doing something wrong. First when I used

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

wksPivotSheet.Name = PivotSummary End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rekha siri Sent: Jan/Fri/2012 10:54 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help in building pivot using vba Need pivot macro

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

hi Ansari, I am bit new to vba coding as this pivot source data is within sheet as per attached sheet . *my query is * if i have data in different sheet please advise. can you please help to provide this below listed steps code 1) to copy particular sheet from one existing workbook to

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

Need pivot macro assistance.. On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare

Re: $$Excel-Macros$$ Re: Need help with screen tip

Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help with screen tip All is there a resolution for this?? Krishnan Sent on my BlackBerryŽ from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Sun, 6 Nov 2011 18:21:31 To: excel-macros

Re: $$Excel-Macros$$ Re: Need help with screen tip

-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help with screen tip All is there a resolution for this?? Krishnan Sent on my BlackBerryŽ from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Sun, 6 Nov 2011 18:21:31

$$Excel-Macros$$ Re: Need help with screen tip

All is there a resolution for this?? Krishnan Sent on my BlackBerryŽ from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Sun, 6 Nov 2011 18:21:31 To: excel-macros@googlegroups.com Reply-To: krishnanm2...@gmail.com Subject: Need help with screen tip All - I need some

Re: $$Excel-Macros$$ Re: Need help with screen tip

You can use hyperlinks with custom screen tips in small shapes placed on top of your actual image, and make those shapes transparent. Regards, Sam Mathai Chacko On Mon, Nov 7, 2011 at 9:02 AM, krishnanm2...@gmail.com wrote: All is there a resolution for this?? Krishnan Sent on my

Re: $$Excel-Macros$$ Re: need help in soting

Hope this will work.. On Fri, Jun 17, 2011 at 11:23 PM, airen airen1...@gmail.com wrote: Members please Help.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Re: need help in soting

Tx Deepak Regards Akhilesh Airen -- -- 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 @

$$Excel-Macros$$ Re: need help in soting

let there is a table and i want to sort the records of this table using some attribute say pin code. the above algo sort only pin codes.. i want to sort records using coding only.. i don't want to use range().sort --

$$Excel-Macros$$ Re: need help in soting

Members please Help.. -- -- 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 @

$$Excel-Macros$$ Re: need help in soting

Your code is working fine...Can you elaborate what do you want to do, exactly? On Jun 16, 3:11 pm, airen airen1...@gmail.com wrote: Sub bubblesort()     Dim i As Integer, j As Integer, n As Integer, temp As Single     n = Selection.Rows.Count     For j = n To 3 Step -1     For i = 1 To j - 1

$$Excel-Macros$$ Re: need help!

Dear Syed, Pls attach the solution file. Pls let me know was it helpful or any problem. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

Subject: Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns =CONCATENATE(A2, ,B2, ,C2) Dave Mar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote: data attached On Mon, Mar 7, 2011 at 3:47 PM, Krish  wrote: Hi , I have data in row and column 1-3, and needs to club

Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns

...@verizon.net *To:* excel-macros@googlegroups.com; kandy.kr...@gmail.com *Sent:* Mon, March 7, 2011 1:32:54 PM *Subject:* Re: $$Excel-Macros$$ Re: need help in excel - data merge acorrs columns =CONCATENATE(A2, ,B2, ,C2) Dave Mar 7, 2011 06:51:07 AM, excel-macros@googlegroups.com wrote

  1   2   3   >