Re: $$Excel-Macros$$ Outlook VBA code to send email notification on a specific date criteria

2015-03-08 Thread Sharath Sambrani
Wonderful! Thanks Vaibhav On Sat, Mar 7, 2015 at 4:22 PM, Vaibhav Joshi wrote: > Hi > > check this : > http://superuser.com/questions/635094/scheduled-and-recurring-email-in-outlook > > > http://www.mrexcel.com/forum/excel-questions/731321-run-outlook-visual-basic-applications-macro-specifi

Re: $$Excel-Macros$$ Need help on data validation: List

2014-11-13 Thread Sharath Sambrani
Thanks Ashish, This is exactly what I wanted! Regards, Sharath On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar wrote: > Hi Sharath, > > PFA..! > > > Change your data in A1. If you select Global in A1 then drop down list > will show in B1 and If you select Local in A1 then drop down list will

Re: $$Excel-Macros$$ Need help on data validation: List

2014-11-13 Thread Sharath Sambrani
Hi Ashish, I am sorry I was not clear in my email. Let me clarify. Cell A1 has a drop down list ("Global", "Local") If someone selects "Global", Cell B1 should show a drop-down list which is coming through a named range. I have that assigned. But, if the user selects "Local", the Cell B1 shoul

Re: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
Thanks Rajan, It worked! Appreciate your quick reply. Cheers, Sharath On Wed, Apr 4, 2012 at 6:13 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > Thanks Rajan, > > It worked! > > Appreciate your quick reply. > > Cheers, > Sharath > > > On W

Re: $$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
t; > If Target.Column = 1 Then > > Target.Value = (Target.Value * 12) / 100 > > End If > > Application.EnableEvents = 1 > > > > End Sub > > ** ** > > ** ** > > Rajan > > *From:* excel-macros@googlegroups.com [mai

$$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
Hello Experts, I have a quick question for you. I am looking for a event macro. Whenever someone inputs a value in any cell under a particular column (say column A) and hits ENTER, the value in the same cell should calculate as (Value x 12)/100. For example, I enter a value in cell A2, the result

$$Excel-Macros$$ Event macro request

2012-04-04 Thread Sharath Sambrani
Hello Experts, I have a quick question for you. I am looking for a event macro. Whenever someone inputs a value in any cell under a particular column (say column A) and hits ENTER, the value in the same cell should calculate as (Value x 12)/100. For example, I enter a value in cell A2, the result

$$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Sharath Sambrani
Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belon

$$Excel-Macros$$ Need help on dynamic list

2010-12-08 Thread sharath sambrani
Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belon

$$Excel-Macros$$ Need help on CONCATENATE and SUM function

2010-06-08 Thread sharath sambrani
Hi, i am trying to use sum function in concatenate function. i want to concatenate 'text' + 'sum of a range' + 'text' i want to use this in a column heading, say cell A1. cells A2, A3 and A4 has number values. in cell i want to display as: FY09-Q4 (4,464) FY10 should be displayed in the first