Re: $$Excel-Macros$$ Re: I want to show flag using conditional formatting

thanx basole, But I want to show flag of icon sets from conditional formatting. Regards, Waseem Saifi On Sat, Oct 5, 2013 at 7:44 PM, Basole wrote: > Hi Waseem, see the suggestion using conditional formatting, only to color > the font and fill the cell. > > > tks. > Basole. > > > > > > Em sáb

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Dear Ashish, Any further help in this matter please. Regards Nasir Khan On Fri, Oct 4, 2013 at 12:38 AM, Nasir Khan wrote: > Yes I did. > But as mentioned in my reply I need the code to > 1) run on all the files in the given Path = Your code run a single folder > at a time...there are several fo

$$Excel-Macros$$ Re: I want to show flag using conditional formatting

Hi Waseem, see the suggestion using conditional formatting, only to color the font and fill the cell. tks. Basole. Em sábado, 5 de outubro de 2013 01h31min52s UTC-3, Waseem Saifi escreveu: > > Hi Experts, > I want to show flag next to value's coulmn basis on criteria that if > value is g

Re: $$Excel-Macros$$ Identifying Excel number format

try this Sub xcv() Dim Data As Range, Rng As Range Set Data = Range("A6") Set Data = Range(Data, Data.End(xlDown)).Offset(, 4) For Each Rng In Data Rng.Offset(, 2) = Rng * IIf(InStr(1, Rng.NumberFormat, "Cr") > 0, -1, 1) Next End Sub Pada 05/10/2013 14:23, Sandee

Re: $$Excel-Macros$$ Material on dashboards

http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/ http://chandoo.org/wp/excel-dashboards/ . Enjoy Team XLS On Sat, Oct 5, 2013 at 2:00 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > Hi, > > Does anyone has goo

Re: $$Excel-Macros$$ Identifying Excel number format

c an you please example your requirement please find attachment hope it fulfill your requirement . Enjoy Team XLS On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer wrote: > PFA the original file. Hope it will work. > > > On 5 October 2013 13:00, ashish koul wrote: > >>

Re: $$Excel-Macros$$ Identifying Excel number format

Excel gurus, Any solution. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Sandeep Chhajer Date: Sat, 5 Oct 2013 15:14:11 To: Subject: Re: $$Excel-Macros$$ Identifying Excel number format PFA the original file. Hope it will work. On 5 October 2013 13:00, ashi

Re: $$Excel-Macros$$ Identifying Excel number format

PFA the original file. Hope it will work. On 5 October 2013 13:00, ashish koul wrote: > i can't see custom format > > > On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer < > chhajersand...@gmail.com> wrote: > >> ** >> Dear Ashish, >> >> This is only original file, I have just cut down the

RE: $$Excel-Macros$$ Complicated Formula (automatic add back)

Query is not clear.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, October 04, 2013 7:05 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Complicated Formula (automatic add back) Dear Experts Pls solution my

Re: $$Excel-Macros$$ Complicated Formula (automatic add back)

Dear All Can anyone solve my issue? Regards Amar On Fri, Oct 4, 2013 at 7:05 PM, amar takale wrote: > Dear Experts > Pls solution my critical formula issue in excel.I hope anyone help me to > resolve this issue. > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Material on dashboards

Hi, Does anyone has good book/video links on dashboards. Please forward me the details. Thanks in advance. Regards, Ashwani -- 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/

Re: $$Excel-Macros$$ Urgent Help.

attachment missing ! On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > > Dear Friend, > > i want to use total no of present or absent list using pivot table. > > Please find the attachment. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > > -- > Are you =EXP(E:RT) or =NOT(E

Re: $$Excel-Macros$$ Re: Urgent Help.

PFA.. solved On Sat, Oct 5, 2013 at 11:23 AM, Rakesh kumar wrote: > Please find the attachment. > > > > On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote: > >> >> Dear Friend, >> >> i want to use total no of present or absent list using pivot table. >> >> Please find the attachment. >> >> >> -

Re: $$Excel-Macros$$ Identifying Excel number format

i can't see custom format On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer < chhajersand...@gmail.com> wrote: > ** > Dear Ashish, > > This is only original file, I have just cut down the number of entries to > certain extent as I am checking my code with lesser data. > > Sent on my BlackBe

Re: $$Excel-Macros$$ Identifying Excel number format

Dear Ashish, This is only original file, I have just cut down the number of entries to certain extent as I am checking my code with lesser data. Sent on my BlackBerry® from Vodafone -Original Message- From: ashish koul Sender: excel-macros@googlegroups.com Date: Sat, 5 Oct 2013 12:55:

Re: $$Excel-Macros$$ Identifying Excel number format

can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer wrote: > Dear Excel Gurus, > > I have facing a peculiar problem related to number format. > When I export any ledger from tally I got result as bellow > > > >Aditya Birla Memorial Hospital 3049.00 3049.00Aditya

$$Excel-Macros$$ Identifying Excel number format

Dear Excel Gurus, I have facing a peculiar problem related to number format. When I export any ledger from tally I got result as bellow Aditya Birla Memorial Hospital 3049.00 3049.00Aditya Enterprises 99521.00 101086.00 *1565.00 Cr* Airways Corporation 39363.80 Dr *39363.80 Dr* Airway