$$Excel-Macros$$ logic used in macro

pls explain the logic used to get output in column Q(considered yes/no) *RequestID* *BankName* *Bank status (Support / Implementation)* *IDU* *Product* *Severity* *LodgedDate* *Version * *InternalStatus* *SLA status (Open / Closed)* *Infy TAT (in Hrs)* *Module* *SLA (in hrs)* *Loc

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Last file is with vba solution. On 1 Jul 2013 21:23, wrote: > ** > Okay! I am not very proficient with VBA. If you pls help me out in this > regard! > > Thanks Sandeep > Sent on my BlackBerry® from Vodafone > -- > *From: * Vabs VBA > *Sender: * excel-macros@googlegrou

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Okay! I am not very proficient with VBA. If you pls help me out in this regard! Thanks Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 21:12:36 To: excel-macros@googlegroups.com Reply-To: excel-m

$$Excel-Macros$$ Requirement of SQl- Data Base Administrator

HEllO ALL, Kindly Go through the following job description and send me the suitable profiles of your consultants at ajay.bharbutta8...@gmail.com *Role: Data base Administrator – SQL* *Location: Minneapolis* *Duration: 1 Year and above* Job Description: - Around 8+ years of experience in Da

Re: $$Excel-Macros$$ Thought you'd find this interesting

Thanks On Mon, Jul 1, 2013 at 7:00 AM, raghu wrote: > ** > Hi, > > I’ve just learned about the water crisis and thought you would be > interested to check out this story: > > https://waterforward.charitywater.org > > Thanks, > raghu >

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Thanks is there any other way out! Table not worked in lower version 97-2003. Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 19:26:21 To: excel-macros@googlegroups.com Reply-To: excel-macros@goog

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Hi In data validation indirect function doesnt work when you you refer to volatile data. You can create a table to accommodate your data. PFA. Thanks On Mon, Jul 1, 2013 at 6:53 PM, wrote: > ** > Any Help in this regard! Any suggestion will be welcomed! > > Sandeep. > Sent on my BlackBerry®

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Any Help in this regard! Any suggestion will be welcomed! Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Mon, 1 Jul 2013 10:39:12 To: excel-macros Reply-To: chhajersand...@gmail.com Subject: Re: $$Excel-Macros$$ Dependent Data valid

Re: $$Excel-Macros$$ Question about function

Thanks for your help Please thank. 2013/7/1 De Premor > istied using SUMPRODUCT, we can also use SUM with CSE > > {=SUM(--($C$2:C2=C2)) &". ("&TEXT(B2,"dd/mm/")&") - "&D2} > > Rgds, > [dp] > > > On 01/07/2013 7:33, Norman Cliff May wrote: > > If the countif function is not available to you,

Re: $$Excel-Macros$$ Pie Chart Help

Respected Priti Madam, I have also pasted the doughnut chart on the pie chart as mentioned by you in the process.After that when I Change the inner doughnut into a pie chart the whole chart is becoming a pie chart and it does not remain a combination chart.I do not understand the reason for this.I

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Hi, Vabs, Actually I have created name range Assets with formula like =(Input!$B$2:$B:$6 ) and another name range i.e. Assets1 with formula =offset(input!$B$2,0,0,counta($B:$B)-1,1) So in second case I.e in Dataval dynamic sheet I have tried to use 'Assets1' as name range instead of 'Assets' a

Re: $$Excel-Macros$$ Unable to Open Excel File... How to repair it..

Hey since you have sent corrupted file. we cant help you on that. Pl send original file before opening the same so we might recover. Thanks On Mon, Jul 1, 2013 at 11:27 AM, B Sharma wrote: > > > Dear Friends and excel experts,,, > I am facing this problem 3-4 time and now I want a remedy /

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Hi PFA. Reason for not working: Defined names & referred name had miss-match. EG. Name has been defined as Assests how ever you was referring to Assets1. Cheers!! On Mon, Jul 1, 2013 at 2:53 PM, wrote: > ** > Pls ignore the previous mail and find the attached file here! > > Sandeep. > Sent

Re: $$Excel-Macros$$ Pie Chart Help

Hi All, I got idea and have plotted, please find the attachment. See if it is ok. if needed please suggest with different charts. Warm regards, Rajan Sharma On Mon, Jul 1, 2013 at 2:42 PM, Rajan sharma wrote: > Dear Priti Mam, > >Thanks for the solution provided. > > Now i am trying to

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Pls ignore the previous mail and find the attached file here! Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 12:52:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Thanks Vabs. pls find the excel file! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Vabs VBA Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 12:52:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Exc

Re: $$Excel-Macros$$ Pie Chart Help

Dear Priti Mam, Thanks for the solution provided. Now i am trying to plot the same graph for different data, i don't understand why it is not working. please check and let me know. As of now, i have inserted some pie-shapes above the Doughnut graph in attachment. please find the attachment fo

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

Hi Vabz, I'hve follow your insturction and I'hve got my answer but when I'hve unhide the sheet, the data will not showing. please help and advise for the same. Thanks, Ashish kumar On Monday, July 1, 2013 2:06:10 PM UTC+5:30, Vabz wrote: > > Hi > > You can hide all unwanted col & rows and prot

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

Hi You can hide all unwanted col & rows and protect workbook so that user will not be having access to that portion. Thanks On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar wrote: > Dear Seniors, > > I have a data from Colum A to Column D in excel sheet, I want show only > this data in sheet & res

Re: $$Excel-Macros$$ Re: Excel - Assighment - Post training evaluation

Hi, Try belo link http://www.wiziq.com/online-tests/19180-advance-excel http://www.gobookee.net/advanced-excel-test-questions-answers/ http://www.accessanalytic.com.au/Free-Excel-Test.html . Enjoy Team XLS On Mon, Jul 1, 2013 at 9:57 AM, Prabhakar S H wrote: > pls he

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, wrote: > Dear Excel expert! > > I am stuck at a point! I have kept five dynamic name range using offset > funtion viz Grouping which has a component like liabilities, asset, income > and expenses. And also have created dynam

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Please if any one know the reason and solution for this revert back!! Sandeep Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 1 Jul 2013 04:37:25 To: excel-macros Reply-To: excel-macros@googlegroups.