Re: $$Excel-Macros$$ Select cells based on custom format

what you want? u need to convert value or else . Enjoy Team XLS On Fri, Jun 27, 2014 at 3:42 PM, Vijayendra Rao wrote: > Dear Experts, > > > > Can you please help me on selecting the cells based on custom format. > > > In attached file some figures contains Dr & Cr.

Re: $$Excel-Macros$$ Export data from excel to tally.

Need to install ODBC... connect excel with ODBC and use... . Enjoy Team XLS On Fri, Jun 20, 2014 at 9:46 PM, Divaker Pandey wrote: > hi experts, > > Is there any way to export data from excel to Tally 9.0 > > Divaker > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

ne cell data validation. > > Regards > Amar > > On Mon, Jun 23, 2014 at 1:18 PM, xlstime wrote: > > Is this fine?.. please check attachment > > > > . > > > > Enjoy > > Team XLS > > > > > > > > On Mon, J

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

rmula in sample sheet,i > will check it > > Thanks > Amar > > > On Mon, Jun 23, 2014 at 12:25 PM, xlstime wrote: > > Dear Amar, > > > > As per my understanding about your requirement, you can use if condition > > with your indirect formula

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

Dear Amar, As per my understanding about your requirement, you can use if condition with your indirect formula . Enjoy Team XLS On Mon, Jun 23, 2014 at 12:06 PM, amar takale wrote: > Dear All Experts > > Can anybody tell me regarding In Data validation Show ALL Crite

Re: $$Excel-Macros$$ Xlsm Password removal

Please follow group rule.. see rule number 3. . Enjoy Team XLS On Sat, Jun 14, 2014 at 11:58 PM, Revathi Nair wrote: > Hello friends, > Please help me to remove password of attached excel file. > > Thanks in advance ! > > Revathy > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ EXCEL PASSWORD REMOVE

Dear Kannan, Please follow group rules 3) Don't post questions regarding breaking or bypassing any security measure. . Enjoy Team XLS On Mon, May 26, 2014 at 11:28 AM, Kannan Excel wrote: > Dear Friends, > > I want to know how to remove password in excel. > Please fi

Re: $$Excel-Macros$$ Open office

Yes, It is possible, please try below link https://wiki.openoffice.org/wiki/VBA_interoperability_in_OpenOffice . Enjoy Team XLS On Sat, May 24, 2014 at 1:58 AM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi, > Can we create macro in open office calc. I n

Re: $$Excel-Macros$$ Password protected work sheet

Thank Paul :) . Enjoy Team XLS On Mon, May 19, 2014 at 4:40 PM, Paul Schreiner wrote: > Yes, there are ways to override (break) passwords. > But, per Forum Rules #3, you shouldn't seek them here. > --- > 3) Don't post questions regarding breaking or

Re: $$Excel-Macros$$ Best? Ms Excel vs Ms Access?

depends on requirement... Access best as Database and Excel best as BI tool . Enjoy Team XLS On Sat, May 17, 2014 at 11:43 AM, Kannan Excel wrote: > *Dear Friends,* > > *Please tell which is the best one, Ms Excel or Ms Access?* > > -- > Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Multiple value to be picked up

what do you mean by multiple.. . Enjoy Team XLS On Sat, May 17, 2014 at 12:49 PM, Pravin Gunjal wrote: > Hello, > > I have attached an excel file. The data is already entered in this file. > > > The "Qty" column must be multiple of "Pack" column. If it is correct th

Re: $$Excel-Macros$$ Password protected work sheet

try below add in http://www.straxx.com/excel/password.xla . Enjoy Team XLS On Sat, May 17, 2014 at 7:04 PM, Robert Lynch wrote: > We have a form we use at work to report client income/expenses which we > would like to modify, We have been able to make some modificatio

Re: $$Excel-Macros$$ Study material for LOOPS

Please check below link http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=122:excel-vba-loops-with-examples-for-loop-do-while-loop-do-until-loop&catid=79&Itemid=475 . Enjoy Team XLS On Sun, Feb 23, 2014 at 11:42 AM, suresh k wrote: > De

Re: $$Excel-Macros$$ convert number to words (with caps letter)

please take reference from below link and use upper case function http://foreignpostmumbai.blogspot.in/2011/11/convert-rupees-in-figure-to-rupees-in.html . Enjoy Team XLS On Mon, Feb 3, 2014 at 2:38 PM, Kannan Excel wrote: > Hi, > > Please help, > How to convert nu

Re: $$Excel-Macros$$ Macro to change existing formatting of numbers based on Criteria

Hi Milin, Hope its fulfill your requirement Thanks Team XLS On 1/5/14, Milin Sulakhi wrote: > Dear All, > > I cannot write macros hence need your help on it . This Macro will achieve > what I have mentioned below. > > 1. There is a range which I will select in excel. > 2. Run Macro > 3. Number

Re: $$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

please elaborate . Enjoy Team XLS On Tue, Dec 17, 2013 at 3:23 PM, sridher sharma wrote: > how do I save a table? I have taken my data, created a table and then > tried to 'save as' but when I reopen it, it is back in the original > worksheet format. What am I missing?

Re: $$Excel-Macros$$ Chart Help

i hope u need this . Enjoy Team XLS On Tue, Dec 17, 2013 at 4:02 PM, wrote: > Hi Team, > > I need your help to modify the attached chart in more attractive way. > Please help me to insert "Sewing Attrition % within the Blue box. and > simlar to other box also. > > P

Re: $$Excel-Macros$$ How to calculate interest in following scenario ?? plz help

Hi Khushal, Need some clarity. it's day wise calculation or after 40days and also share the example with both condition due date archived and not archived . Enjoy Team XLS On Sat, Dec 21, 2013 at 8:16 PM, khushal wrote: > I need to calculate amount of interest rec

Re: $$Excel-Macros$$ Project ETA Calculation

Hi Arul, Please share the example. so that we can easily execute the formula . Enjoy Team XLS On Sun, Dec 22, 2013 at 6:03 AM, Arulkumar wrote: > Hi All, > > Please help on below email. > > I need a formula or macro for ETA calculation. > > Regards, > Arul. > On Dec

Re: $$Excel-Macros$$ How to protect macro code with a password?

In the Visual Basic Editor, Tools > VBAProject Properties > Protection tab. . Enjoy Team XLS On Sun, Dec 15, 2013 at 8:41 AM, rpm wrote: > Hi, > > Pls help me to protect my code with a password...! > > > Regards, > Roshan Mathew > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ Introduction to Array Formulas

Dear Anoop, Request you to please do not send our web link.. this group for Questioning and answering not a advertisement Ayush:- Please take a action . Enjoy Team XLS On Tue, Dec 10, 2013 at 8:09 PM, anoop kumar wrote: > > http://excelautomate.blogspot.in/2013/12/

Re: $$Excel-Macros$$ To one digit calculation

please share the sample sheet . Enjoy Team XLS On Thu, Nov 28, 2013 at 8:53 PM, Kongsambath PEN wrote: > Hi there, > > Hi, > > Please help me out in excel to find functions in the result cell following > by calculation. > > >

Re: $$Excel-Macros$$ Numbers in words with formula

read below link http://support.microsoft.com/kb/213360 . Enjoy Team XLS On Fri, Nov 29, 2013 at 9:27 AM, excel lerner wrote: > Hi experts > > Please help me to convert numbers in to words in excel 2007.is there any > formula to cinvert. > > Rs.1234 .56 Result is On

Re: $$Excel-Macros$$ Value formula is not working

> 9920553518 > On 25-Nov-2013 1:53 PM, "xlstime" wrote: > >> please share the snap shot >> >> . >> >> Enjoy >> Team XLS >> >> >> >> On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav > >

Re: $$Excel-Macros$$ Value formula is not working

Jadhav > wrote: > >> Dear Sir, >> It is also not working ... >> >> Value error is there . >> >> Regards, >> Prafull Jadhav >> 9920553518 >> >> >> On Mon, Nov 25, 2013 at 1:43 PM, xlstime wrote: >> >&g

Re: $$Excel-Macros$$ Value formula is not working

you can try with "--" formula like =--A3 . Enjoy Team XLS On Mon, Nov 25, 2013 at 1:19 PM, Prafull Jadhav wrote: > Dear All , > > Very Good Afternoon, > > Please find the attachment where i have put value formula for date column > ..but it is not working ..Same formu

Re: $$Excel-Macros$$ Wants to do repeated steps of Macro till last column

i have just add loop Sub rr() For i = 3 To 78 Cells(4, i).Select Selection.Delete Shift:=xlUp Cells(4, i).Select Range(Selection, Selection.End(xlDown)).Select Range(Cells(3, i), Cells(2028, i)).RemoveDuplicates Columns:=1, Header:=xlYes Next End Sub . Enjoy Team

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$

"creditor details" sheet missing . Enjoy Team XLS On Sat, Nov 16, 2013 at 6:39 PM, Sharad Shroff wrote: > The attach file has a worksheet named Sub-Ledger which contains List > of Sundry Creditors with their address and other detail > > i want the list of sundry cred

Re: $$Excel-Macros$$ Pivot Table Query

place "Return type" in column Labels . Enjoy Team XLS On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal wrote: > *Hello,* > * > * > *I have created a pivot table for attached file as per column F, I & M > from Data Sheet. * > * > * > *I want the total of return types “E

Re: $$Excel-Macros$$ Pivot table format

not possible in pivot table use separately 1. Select the range that contains blank cells you need to fill. 2. Click Home > Find & Select > Go To Special…, and a Go To Special dialog box will appear, then check Blanks option. 3. Click OK, and all of the blank cells have bee

Re: $$Excel-Macros$$ How to install power pivot addin

if u want to install powerpoint add simply use excel shortcut (alt+T+I) . Enjoy Team XLS On Sun, Oct 27, 2013 at 10:07 AM, Amit Desai (MERU) wrote: > Dear Friends, > I would like to install power pivot addin in excel. I have excel 2010 > installed on my home PC. I hav

Re: $$Excel-Macros$$ Sorting of Row in Go

hope i understand ur requirement . Enjoy Team XLS On Thu, Oct 24, 2013 at 2:33 PM, Prabhakar S H wrote: > Hi Team, > > Need your help to sort (In one Short) Rows in Ascending order without > using Macro or ASAP Utilites. Pls help. > > Rgds, > Prabhakar > > -- > Are y

Re: $$Excel-Macros$$ Meaning of "Value 2"

; *Regards, > Prafull Jadhav > 9920553518* > > > On Thu, Oct 24, 2013 at 1:00 PM, xlstime wrote: > >> Value2 always uses the same value that Excel uses. It does not truncate >> decimal places ,Value2 gives you DateSerial so you know exactly which day &

Re: $$Excel-Macros$$ Meaning of "Value 2"

Value2 always uses the same value that Excel uses. It does not truncate decimal places ,Value2 gives you DateSerial so you know exactly which day is meant. Same thing with currency and decimal/digit grouping symbols. . Enjoy Team XLS On Thu, Oct 24, 2013 at 9:29 AM, Pra

Re: $$Excel-Macros$$ Formula Required

please share the example . Enjoy Team XLS On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < prabhakarthak...@gmail.com> wrote: > Dear Team, > > > > > > I need a formula for create unique ID. > > > > Unique ID=first character of first Name + last name first character

Re: $$Excel-Macros$$ Paste special using skip blank

as per my understanding its not possible ... we need to create SUB or sort data before paste special or . Enjoy Team XLS On Fri, Oct 18, 2013 at 10:59 PM, Manoj Kumar wrote: > Hi Team > > Can anyone suggest me that. How can I paste data using skip blank. > That all

Re: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA

little changes =INDIRECT(E$2&"!BT"&ROWS(E$1:E5)) . Enjoy Team XLS On Fri, Oct 18, 2013 at 11:05 AM, xlstime wrote: > > > . > > Enjoy > Team XLS > > > > On Fri, Oct 18, 2013 at 11:0

Re: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA

. Enjoy Team XLS On Fri, Oct 18, 2013 at 11:02 AM, xlstime wrote: > use INDIRECT function > > =INDIRECT(E$2&"!BT5") > > . > > Enjoy > Team XLS > > > > On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gu

Re: $$Excel-Macros$$ How to take values from other sheets with single formula or VBA

use INDIRECT function =INDIRECT(E$2&"!BT5") . Enjoy Team XLS On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal wrote: > *Hi,* > > * * > > *I want to take the values from Apr to Mar sheets from “BT” column in > this sheet.* > > *I have used this formula “=Apr!BT4”, but

Re: $$Excel-Macros$$ MS Excel 2003 to 2010

Hi Prashant, Please download Interactive menu to ribbon guide http://www.microsoft.com/en-us/download/confirmation.aspx?id=16642 . Enjoy Team XLS On Mon, Oct 14, 2013 at 3:21 PM, Prashant Pednekar wrote: > Dear friends > > We are migrating from MS Excel 2003 to Excel

Re: $$Excel-Macros$$ DEFINE NAME FUNCTION

Go to Name Manager (shotkey Alt+I+N+D) and change range . Enjoy Team XLS On Sat, Oct 12, 2013 at 10:34 PM, SUDHIR VERMA wrote: > Dear Experts, > > How to edit edit in Define Name Function after applicable. > > > Thanking You > > Regards > > Sudhir > > -- > Are you =EX

Re: $$Excel-Macros$$ Error while opening file

Use file extension finder (Software).. . Enjoy Team XLS On Fri, Oct 11, 2013 at 9:24 AM, Rajan sharma wrote: > > Dear Experts, > >I am unable to open the excel file. i am getting like the attached > file. please provide me a solution. > > > > With warm regards, > R

Re: $$Excel-Macros$$ Date format system using VBA

please share ur vba code with example sheet . Enjoy Team XLS On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan < viswanathan.yoganat...@asia.xchanging.com> wrote: > Hi, > > I am copying the date as text from one sheet and pasting to another sheet > using the co

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$$ Data Entry Form/Database

no its not possible with only excel... need to create another database like ..ms access or sql . Enjoy Team XLS On Wed, Oct 2, 2013 at 3:53 PM, Bv Dileep wrote: > Hi Experts, > > We have 10 associates, they are updating the data in different excel > workbooks. at the

Re: $$Excel-Macros$$ How to take the data from the webpage table and paste it in the excel

Go to "Data" menu option and select in "Get External Data" From WEB and simply record macro your self. . Enjoy Team XLS On Sat, Sep 28, 2013 at 11:34 AM, Menaka Balakrishnamoorthy < menaka.balakris...@gmail.com> wrote: > > > HI, > > I want to take the data from the w

Re: $$Excel-Macros$$ to

Visit below group link http://groups.google.com/group/excel-macros. and click on "Apply to joingroup" . Enjoy Team XLS On Sat, Sep 28, 2013 at 10:41 AM, TIWARI wrote: > dear Sir, > How can make new member of excel-macros groups. > > -- > Are you =EXP(E:RT) or =NOT

Re: $$Excel-Macros$$ Auto filter subtotals - names wont appear in the subtotal row - please help its driving me crazy !

can u please share the output example? . Enjoy Team XLS On Sat, Sep 28, 2013 at 5:24 PM, Johnnyboy5 wrote: > have a main sheet with a list of 51 unique names in Column B and then > lots of data in other columns across the sheet. > > I have other sheets in the same sa

Re: $$Excel-Macros$$ Filter Data of Bold letter

Hi, Please read below link http://support.microsoft.com/kb/213923 . Enjoy Team XLS On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara wrote: > Dear experts, > > I have a data columnar and want filter only bold letter data, is it > possible, if yes please tell me how it

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

Please add false statement =IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV", *"")*)) . Enjoy Team XLS On Mon, Sep 9, 2013 at 12:33 PM, Angel Araneta wrote: > >

Re: $$Excel-Macros$$ combined formula required.

------ > *From:* xlstime > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, September 8, 2013 3:47 PM > *Subject:* Re: $$Excel-Macros$$ combined formula required. > > can u please share full condition > > . > > Enjoy > Team XLS >

Re: $$Excel-Macros$$ combined formula required.

can u please share full condition . Enjoy Team XLS On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala wrote: > Hi group, > > I want a combination of "IF" and "AND" formula, or any other other > suitable formula for inserting some indicators between fixed set of values. > >

Re: $$Excel-Macros$$

Hi, Just UN-check "Check compatibility when using saving this workbook" or save file in XLSX format . Enjoy Team XLS On Thu, Sep 5, 2013 at 1:06 PM, Chandra Shekar wrote: > Hello Ashish, > > Could you please let me know why Chart disapperars while saving the file,

Re: $$Excel-Macros$$ Re: DATE Conversion - Gregorian to Hijri

pls share . Enjoy Team XLS On Fri, Aug 30, 2013 at 9:25 PM, mahmoud aqajari wrote: > Hi Ahmad > Iam Mahmoud,Ihave a converter gregorian to hijri shamsi.if you need this > tell me. > > > On Wed, Aug 14, 2013 at 2:15 AM, hansel jose wrote: > >> Pls try with this file .

Re: $$Excel-Macros$$ Copy data to next empty row

try below code i = WorksheetFunction.CountA(Range("a:a")) + 1 Range("a" & i).Select . Enjoy Team XLS On Fri, Aug 30, 2013 at 10:09 AM, DanJ wrote: > Dear Experts, > > I have a range, * A37:A115,* in my first (1st) workbook where I copy > and paste data from my seco

$$Excel-Macros$$ Very important document

Good day, Please view the document I uploaded for you using Google docs. CLICK HERE just sign in with your email respectively to view the document It's very important Thank You . Enjoy Team XLS -

Re: $$Excel-Macros$$ need help to create Manpower Assigning report

what you want?.. . Enjoy Team XLS On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan wrote: > Dear Friends > > kindly hep me to create a manpower assigning report. > > E.g: > > *Project name *:xx > *Input:* > *Per day target*:according to project name its should target val

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

y Team XLS On Wed, Aug 28, 2013 at 10:54 PM, Divaker Pandey wrote: > Sorry I can't send original file, but i am sending you a sample. > > > On Wed, Aug 28, 2013 at 10:40 PM, xlstime wrote: > >> I >> think it's not possible, can u please share ad

Re: $$Excel-Macros$$ Output Requier in Vertical

uld be like >> ABDE.continue >> but how it come >> AABBBBBCCDDDEEFHHHIIJKLLMN >> >> Please explain. >> It working very fine as per my desire output >> >> >> >> On Wed, Aug 28, 2013 at 10:34 AM, xlstime wrote: >

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

y this problem > remains.? > > I can't send code with excel file. is there another way to solve out this > problem? > > Thanks > Divaker > > > On Wed, Aug 28, 2013 at 9:21 PM, xlstime wrote: > >> because the addin is installed in your system.. t

Re: $$Excel-Macros$$ VBA getting data from web site

you can try "data import from web" j ust press alt+a+fw . Enjoy Team XLS On Wed, Aug 28, 2013 at 6:59 PM, Mithun Dhar wrote: > I am trying to import data from IE sharepoint web site. The sharepoint > website just contains one table with headings and data. If I go

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

because the addin is installed in your system.. thats why another user get convert formula to addin path suggestion/solution :- you can paste your addin code in your workbook so thats no need for addin . Enjoy Team XLS On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey w

Re: $$Excel-Macros$$ Output Requier in Vertical

PFB Sub amit() For K = 1 To Range("B2:X15").EntireRow.Count For P = 1 To Range("B2:X15").EntireColumn.Count Range("AA500").End(xlUp).Offset(1, 0).Value = Range("B2:X15").Cells(K, P) Range("AA500").End(xlUp).Offset(0, -1).Value = Range("a2:a15").Cells(K, 1) Next Next End Sub ...

Re: $$Excel-Macros$$ Datavalidation

You can use cut and paste opetion . Enjoy Team XLS On Tue, Aug 27, 2013 at 12:47 PM, Smitha S R wrote: > Hi , > > Please help.. > > > On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R wrote: > >> Hi, >> >> Please suggest option to prevent copy paste in cells with data val

Re: $$Excel-Macros$$ listbox issue

can u please share the example workbooks for better understanding . Enjoy Team XLS On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski wrote: > Hi All, > > I have quite serious problem with the list box (ActiveX). when I use it on > the sheet where is placed is fine, but

Re: $$Excel-Macros$$ Query Regarding Pivot Table

Yes, it is possible via "Multipal consolidate ranges" Just press Alt+D+P then select "Multipal consolidate ranges" . Enjoy Team XLS On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi wrote: > Dear Experts, > >Is it possible to make a pivot table basis on two workbooks

Re: $$Excel-Macros$$ CALL Userfom Another Workbook

what we can do?...both workbooks VBA coding is password protected . Enjoy Team XLS On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal < sanjaykumarmanda...@gmail.com> wrote: > Dear all > > MIS Details 2013 to 2014 IN* CALL USERFORM* DAILY TRANSFER SHEET-13 > > *Regard

Re: $$Excel-Macros$$

Hi Ali, We can use Sumifs or Sumproduct =SUMPRODUCT(($B$1:$B$27>=41317)*($B$1:$B$27<=41325),$A$1:$A$27) =SUMIFS($A$1:$A$27,$B$1:$B$27,">="&41317,$B$1:$B$27,"<="&41325) . Enjoy Team XLS On Thu, Aug 22, 2013 at 8:33 PM, Ali Abbas wrote: > Dear all. How can we calcula

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate ch.Chart.ChartTitle.Select Selection.Format.TextFrame2.TextRange.Font.Name = "Arial" Selection.Format.TextFrame2.TextRange.Font.Size = 14 Next End Sub

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

Hi, Please elaborate some more "OUTPUT REQUIRED" with any specific value or just group concatenate, if any specific value please mention please explain role of "CODES" or "Text" column . Enjoy Team XLS On Sun, Aug 18, 2013 at 9:32 PM, Rashid Khan wrote: > Hello Al

Re: $$Excel-Macros$$ clubbing 200 excel files

try below code just change Path or filename name extn. (.xls to .xlsx or other ) Sub clubefile() Dim num As Integer Dim x As Integer Path = "C:\Documents and Settings\xlstime\Desktop\delete\" Filename = Dir(Path & "*.xls") Do While Filename <> &quo

Re: $$Excel-Macros$$ need basic macro commands - Reg

try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Thu, Aug 15, 2013 at 1:13 PM, jmothilal wrote: > Dear All > > Request to send basic macro commands like for loop, assigning value , > detecting row and column value .. etc > > i know the c

Re: $$Excel-Macros$$ identifying no of people people in a particular age

Hi, Try below code for consolidate worksheet.. then use pivot table for 2nd requirement or send the example sheet Sub Combine() Dim NumSheets As Integer NumSheets = Worksheets.Count Worksheets(1).Select Sheets.Add ActiveSheet.Name = "Consolidated" For X = 1 To NumSheets Worksheets(X + 1).Select

Re: $$Excel-Macros$$ VBA Macros classes

Hi Niraj, You can learn VBA online... try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Sun, Aug 4, 2013 at 10:46 AM, Niraj Shirali wrote: > Hi, > > I'm new to this group and I'm hoping someone to help me guide. I'm from > Mumbai and am look

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Niraj . Enjoy Team XLS On Sun, Aug 4, 2013 at 10:56 AM, Niraj Shirali wrote: > Hello All, > > My name is Niraj Shirali, from Mumbai. Working with BNY Mellon. Looking > forward to learn VBA_macros in depth. Have developed some automations in > the past with some

Re: $$Excel-Macros$$ Auto Rate taking- !!! HELP PLZ !!!

If i am correct Please find below formula =VLOOKUP(C8,$I$7:$J$9,2,0)*(1+$G$3%) . Enjoy Team XLS On Thu, Aug 1, 2013 at 7:51 PM, SAJID MEMON wrote: > Dear Experts, > > My project in last stage, just your little co-operation I will complete my > project. > please give

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

please check you group setting -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Plea

Re: $$Excel-Macros$$ Tricky tricks - 1

> Next > End Sub > > Regards, > Prafull > > > On Tue, Jul 30, 2013 at 12:31 PM, xlstime wrote: > >> if we have more then thousands of records than? >> >> . >> >> Enjoy >> Team XLS >> >> >&g

Re: $$Excel-Macros$$ Tricky tricks - 1

; >> create defined name in example : "*Eval**A2*" that referring to >> =EVALUATE(A2) >> >> Then in some cell in that sheet, just type *=EvalA2** >> * >> >> >> Pada 28/07/2013 14:59, xlstime menulis: >> >> and what about formula

Re: $$Excel-Macros$$ Tricky tricks - 1

* > **End Function** > * :-X > > On 28/07/2013 12:09, xlstime wrote: > > Hi All, > > How to Evaluate cell value. > > let assume that, in cell A2 - '1+2+3+4' > > now how to sum or calculate cell value > > hint: evaluate > > ...

$$Excel-Macros$$ Tricky tricks - 1

Hi All, How to Evaluate cell value. let assume that, in cell A2 - '1+2+3+4' now how to sum or calculate cell value hint: evaluate . Enjoy Team XLS -- 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 Faceb

Re: $$Excel-Macros$$ 9e+307

Santoh, 9E+307 is the largest numeric value that can be represented in Excel. . Enjoy Team XLS On Thu, Jul 25, 2013 at 1:09 AM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > Need information on what is 9E+307 and when/where/how to use it. >

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi Ashish, Try this Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) StrNew = Mid(strOld, i, 1) & StrNew Next i Reverse = StrNew End Function .

Re: $$Excel-Macros$$ indirect function syntax

. Enjoy Team XLS On Sun, Jul 21, 2013 at 12:54 AM, MLT wrote: > I'm trying to figure out the syntax to use a function within the Indirect > function. I would like to do something like this but am getting a #REF > error: > > =INDIRECT("SUM(A1:A3)") > > > Where am I goi

Re: $$Excel-Macros$$ Error in output

I missing in our formula (iserror) =IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),"",C1) . Enjoy Team XLS On Tue, Jul 9, 2013 at 5:22 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Sir, kindly give solution for the attached file, > thanks in advance > >

Re: $$Excel-Macros$$ Error in Excel Report

Please elaborate some more . Enjoy Team XLS On Thu, Jul 4, 2013 at 4:49 PM, Manoj Kumar wrote: > > > > > On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar wrote: > >> >> Dear Expert, >> >> Please help to sove my Quiry file attached in mail. >> >> i need fill all data with

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$$ Macro Require

why need macro ?try pivot table please find attached file . Enjoy Team XLS On Thu, Jun 27, 2013 at 6:30 PM, vikas khen wrote: > > Dear All, > > > Please find the excel sheet. I need macro for the same > > > > Regards > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Welcome Sandeep Looking forward to your active participation in group. Keep posting . Enjoy Team XLS On Thu, Jun 27, 2013 at 10:57 AM, sandeep shivpujan singh < mandy07s...@gmail.com> wrote: > Hi Everyone, > > I am Sandeep S Singh from India > Hyderabad. I am a Soft

Re: $$Excel-Macros$$ formula require

Hi Prabhakar, *Please find attached solution...hope its fulfill your requirement * . Enjoy Team XLS On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > Hi Team, > > I want to split data into name, bank account no & ifsc code separetely in > attached file. Please h

Re: $$Excel-Macros$$ Average

Hi Deepak, Please elaborate your requirement little more. . Enjoy Team XLS On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti wrote: > Dear Ahmed, > Thanks for your reply. avergeifs does not meet as per my requirement. It > is working for complete column but I am looki

Re: $$Excel-Macros$$ Tutorial on SQL

try below link http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Tue, Jun 11, 2013 at 4:26 PM, Gaurav Garg wrote: > Hello Friends, > > ** ** > > Does anyone have training material on VBA? Could you please share. > > ** ** > > In case if anyone know

Re: $$Excel-Macros$$ find and remove text

try below formula combination with Left and find formula =LEFT(G10,FIND("-",G10)-1) . Enjoy Team XLS On Fri, Jun 7, 2013 at 12:13 PM, Rahul Sharma wrote: > hi folks, > i need a formula that can find the text string and remove from the name. i > have 1500 name store

Re: $$Excel-Macros$$ Conditional Search & Replace

try below VBA code Sub conditionalreplace() Dim rng As Range For Each rng In Range("D1:D10") If rng.Value < 0.8 Then rng = .80 End If Next End Sub . Enjoy Team XLS On Thu, Jun 6, 2013 at 11:18 AM, Amit Desai (MERU)

Re: $$Excel-Macros$$ Error show while excel file opening

Hi Amar, Just press Alt+E+K then change source or break link if no need [image: Inline image 2] . Enjoy Team XLS On Fri, May 31, 2013 at 3:21 PM, amar takale wrote: > Dear All > Can anybody tell me why Error show while excel file opening.when I open > excel file the

Re: $$Excel-Macros$$ Changing Data Source

you can define range name using Name Define manager . Enjoy Team XLS On Fri, May 31, 2013 at 10:31 AM, Amit Desai (MERU) wrote: > I have multiple Pivots in which I need to change the data table range > all together.. > > ** ** > > Is there any shorter way to do t

Re: $$Excel-Macros$$ Problem in Line Graph

Hi Chander, Change Switch Row/Column Right click in chart then go to select data then Switch Row/Column Hope it's fulfill your requirement . Enjoy Team XLS On Thu, May 30, 2013 at 8:02 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I have issue

Re: $$Excel-Macros$$ Video in Word File

firstly install flash player then try to play and for more information about Embed swf in word file http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/ . Enjoy Team XLS On Thu, May 30, 2013 at 5:12 PM, Pravin

  1   2   3   >