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? > =IF(A1>B1,"Buy1",IF(A1 Thanks, David >

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 y

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 > working. > > .Add Type:

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, Formula1:="=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A$2:$A$100))"

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. > > once again Thanks a l

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, B

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 = w

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 i

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

Yes, Minimum Value On Mon, Jun 1, 2015 at 12:12 PM, Mandeep Baluja 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. > https://www.facebook.com/groups/825221420889809/ > h

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 wrote: > Sorry I'm an excel noob, I don't u

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 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 > add to the A col

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 : > Hi Basole, > > It's working fine now following are the only problems remaining. > 1. While creating macro, I have assigned "ctrl+q" shortcu

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

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 : > Hello All, > > I made my first macro code. Kindly review. Now only problem rema

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

Please forum members don’t pay attention on this totally fraud……….mail…. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Basole Sent: Tuesday, December 17, 2013 7:15 PM To: excel-macros@googlegroups.com Cc: philip...@yahoo.com Subject: $$Excel-Macros$$ Re

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 and

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 wrote: > can you attach the sample sheet > > > On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote: > >> Dear wabs, >> Thanks for your reply. >> The amount should be allocated eq

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 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 prorata basis. It wor

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 AutoComplete with Custom List

ber 2012 5:40 > *To:* excel-macros@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

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 us

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, Swap

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, Se

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 wrote: > Hi > > Please refer link for details: > > Link > > > Rgds//Vabs > > On Tuesday, September 25, 2012 3:24:58 PM

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

gesh Vimay 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 wrote: > Hi Mangesh, > > Try usi

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

Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest 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 being in a sheet when

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 t

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

Hi Howard, It's late here, but you have at least one problem. In the following line: mycolor = cBWTStop.Cells(ActiveCell.Row, ActiveCell.Column).Font.Color you reference the activecell.row and .column; but that gives you the row and column for the active cell relative to the sheet as a whole.

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

Try this: Sub CreatePivot() Dim wksPivotSheet As Worksheet Dim wksWest As Worksheet Set wksPivotSheet = ThisWorkbook.Worksheets.Add Dim oPC As PivotCache Dim oPT As PivotTable Dim oWS As Worksheet Set oWS = ActiveSheet Set oPC = ActiveWorkbook.PivotC

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

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

all your help Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Tue, 8 Nov 2011 20:59:17 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need help with screen tip Like I

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

Like I mentioned yesterday, you can use hyperlinks with custom screen tips in small shapes placed on top of your actual image, and make those shapes transparent. If you need an example of how this can be done, revert. Regards, Sam Mathai Chacko On Tue, Nov 8, 2011 at 10:34 AM, wrote: > All sor

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

All sorry to be a pain... But is there some way that this can be done?? Thanks for all your help. Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 7 Nov 2011 03:32:14 To: Reply-To: excel-macros@googleg

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, wrote: > All is there a resolution for this?? > > Krishnan > Sent on my BlackBerryŽ from Vodafone > >

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

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

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

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

hing! > > Paul > > -- > *From:* "davidpk...@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 &

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

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: data attached > > >On Mon, Mar 7, 2011 at 3:47 PM,

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

=CONCATENATE(A2, " ",B2," ",C2)DaveMar 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 the data insingle row and column since the data acorss three columns,Pls help me.Reg

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

On 3/7/11, girish kumar wrote: > Hi Krish, > > use concatenate formula see attached > > On Mon, Mar 7, 2011 at 3:49 PM, Krish 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 the data in >>> sing

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

Hi Krish, use concatenate formula see attached On Mon, Mar 7, 2011 at 3:49 PM, Krish 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 the data in >> single row and column since the data acorss three col

Re: $$Excel-Macros$$ Re: Need Help in Cross tab

I want to do by using a simple click of button as this the problem is the small part of my complete project and once the report is generated ...I need to do more calculation ..a vba code is required so that a baby can generate the qa report Thanks Shariq Sent on my BlackBerry® from Vo

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

if you find better solutions pls reply On Thu, Mar 11, 2010 at 10:56 PM, Harpreet Singh Gujral wrote: > Hi Imran, > > I have followed the following logic: > > In Column G, i have entered a IF Statement, which will seek for Text in > columns H to M, as soon as it finds and text in any of the firs

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

You are welcome Ashish!!! Regards, Praveen On Sat, Feb 6, 2010 at 3:21 PM, ashish koul wrote: > > thanks a lot praveen > >> >> >> -- Forwarded message -- >> From: kvc praveen kumar >> Date: Sat, Feb 6, 2010 at 11:11 AM >> Subj

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

thanks a lot praveen > > > -- Forwarded message -- > From: kvc praveen kumar > Date: Sat, Feb 6, 2010 at 11:11 AM > Subject: Re: $$Excel-Macros$$ Re: need help > To: excel-macros@googlegroups.com > > > Check the attached file. > > Praveen &

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

Check the attached file. Praveen On Fri, Feb 5, 2010 at 11:27 AM, ashish koul wrote: > any help > On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote: > >> hi >> >> i have a input in sheet 1 and its not limited >> >> and want result in sheet2 like in col1 >> >> >> regards >> >> ashish >> > > -

Re: $$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

Hi Vallinayagam, Thanks a tonne for your help. It's working great. I would like to get more help on this. If data structure changes then I may need to edit the codes according to that. Instead of that input boxes have to get the input from me for column name to use for Row field (e.g. A to