Re: $$Excel-Macros$$ Macro Require

Hi Team XLS / Ravinder, Thank you so much for given me the solution. you people are genius. *Regards* On Fri, Jun 28, 2013 at 1:11 PM, ravinder negi wrote: > Hi, PFA for you solution.. > > --- On *Thu, 6/27/13, xlstime * wrote: > > > From: xlstime > Subject: Re: $$Excel-Macros$$ Macro Re

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

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 dynamic name range for all of the components! My name range are working perfectly when I am u

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

pls help On Saturday, June 29, 2013 10:08:28 AM UTC+5:30, Prabhakar S H wrote: > Dear Team, > > I have given training to my team on Excel basic & advance (Files > attached). now i want to give post trainng assighment. > > Hence i need your help to prepare assighment on excel . Pls help. >

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

Dear Seniors, I have a data from Colum A to Column D in excel sheet, I want show only this data in sheet & rest of sheet will be deleted and cursor will be working only from Column A to Column E. like in JPEG image attached. kindly find the attachment for refrence. Thanks, Ashish -- Are y

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

Hi! I’ve just learned about the water crisis and thought you would be interested to check out this story: https://waterforward.charitywater.org/et/qgN1rodl Thanks, raghu -- Sent via WaterForward, an initiative of charity: water WaterForward, 387 Tehama Street, San Francisco, CA 94103, US

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

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, the following formula should work in cell E2 and copy down. =SUMPRODUCT(-

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

If the countif function is not available to you, the following formula should work in cell E2 and copy down. =SUMPRODUCT(--($C$2:C2=C2))&". ("&TEXT(B2,"dd/mm/")&") - "&D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered F. > > Ques

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

Another suggestion would be to put the following formula in cell E2 and copy down. =COUNTIF($C$2:C2,C2)&". ("&TEXT(B2,"dd/mm/")&") - "&D2 Delete the columns to the right of column E On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered

$$Excel-Macros$$ RE: Macro Staff Hierarchy

HI all, Is it possible to do the attached in Vba / Macro. Any help would be appreciated Dii -- 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

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

I think the following formula does everything you are wanting to do if you paste it into cell F2 and copy down. =IF(E1=E2,(LEFT(F1,FIND(".",F1,1)-1))+1,1)&". ("&TEXT(B2,"dd/mm/")&") - "&D2 Then you could delete the columns to the right of column F On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn

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

Change the formula in J2 from =F2&G2&H2&I2&D2 to =F2&G2&TEXT(H2,"dd/mm/")&I2&D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn wrote: > Question 1: I need one function to the column numbered F. > > Question 2: In column J, How to connect string (F & G & H & I & D), > without losing formatting

$$Excel-Macros$$ Validation through Macro!!!

Hi All, PFA. I want to create the validation through Macro, can the EXPERTS help me on this? Requirement is on the 1st sheet and the Table data is on the 2nd sheet. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and inten

Re: $$Excel-Macros$$ mail massage from worksheet

PFA, i've change your path to fit in my computer, change it back to your saving data directory Set fld = fso.getfolder("B:\Learn\FSO") Also in Cell E3, fill with correct path and file name Rgds, De Premor On 28/06/2013 19:10, Satendra kumar wrote: hi sir,, please find attachment i have need

Re: $$Excel-Macros$$ Re: Formula require

Thanks Mr Vijay, Using -- operator, I am able to convert Numeric Characters to Numeric value. (Example : entered =--a1 in cell A2 to convert the character contents from cell a1). Similerly, is there any similler operator is available to convert it back to character except single / double Quote.

Re: $$Excel-Macros$$ Protect & unprotect query

hey you missing additional control.. Your cells are not locked, lock & then protect.. Cheers//Vabs On Sun, Jun 30, 2013 at 3:44 PM, Pravin Gunjal wrote: > Hi Experts, > > I have assigned the macro to attached file for protect and unprotect the > sheet manually. But it is not working properl