$$Excel-Macros$$ Identifying Excel number format

2013-10-05 Thread Sandeep Chhajer
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*

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

2013-10-05 Thread ashish koul
can u share the orginal file On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer chhajersand...@gmail.comwrote: 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

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

2013-10-05 Thread Sandeep Kumar Chhajer
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 koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date:

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

2013-10-05 Thread ashish koul
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 BlackBerry®

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

2013-10-05 Thread Seraj Alam
PFA.. solved On Sat, Oct 5, 2013 at 11:23 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: Please find the attachment. On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: Dear Friend, i want to use total no of present or absent list using pivot table. Please

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

2013-10-05 Thread Waseem Saifi
attachment missing ! On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: 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

$$Excel-Macros$$ Material on dashboards

2013-10-05 Thread ashwani agnihotri
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 @

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

2013-10-05 Thread amar takale
Dear All Can anyone solve my issue? Regards Amar On Fri, Oct 4, 2013 at 7:05 PM, amar takale amartak...@gmail.com 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

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

2013-10-05 Thread Ravinder
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$$ Identifying Excel number format

2013-10-05 Thread Sandeep Chhajer
PFA the original file. Hope it will work. On 5 October 2013 13:00, ashish koul koul.ash...@gmail.com 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

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

2013-10-05 Thread Sandeep Kumar Chhajer
Excel gurus, Any solution. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Sandeep Chhajer chhajersand...@gmail.com Date: Sat, 5 Oct 2013 15:14:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Identifying Excel number format PFA the original

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

2013-10-05 Thread xlstime
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 chhajersand...@gmail.comwrote: PFA the original file. Hope it will work. On 5 October 2013 13:00,

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

2013-10-05 Thread xlstime
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 good

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

2013-10-05 Thread De Premor
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, Sandeep

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

2013-10-05 Thread Basole
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

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

2013-10-05 Thread Nasir Khan
Dear Ashish, Any further help in this matter please. Regards Nasir Khan On Fri, Oct 4, 2013 at 12:38 AM, Nasir Khan nasirkhan.du...@gmail.comwrote: 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