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

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

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

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

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

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

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

"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$$ 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$$ 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$$ 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$$ 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

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

<    1   2   3