Re: $$Excel-Macros$$ Format control percentage value

One more question ask you what changes if 3D shading box clock & remove click On Sat, Sep 1, 2012 at 10:36 AM, amar takale wrote: > Dear Noorin, > Thanks very much but i will ask you there are cell D6 & E6 depend on B6 & > C6.Can there direct option to D6 & E6 in percentage bcos there are extra

Re: $$Excel-Macros$$ Format control percentage value

Dear Noorin, Thanks very much but i will ask you there are cell D6 & E6 depend on B6 & C6.Can there direct option to D6 & E6 in percentage bcos there are extra two cell B6 & C6 increased in numbers format it is compulsory to set in numbers format cell.I have may rows so every head like sales,ebit,

RE: $$Excel-Macros$$ Help on Formula

=INDIRECT("'" & E2 & "'!B2") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 01 September 2012 10:35 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on Formula

$$Excel-Macros$$ Help on Formula

Dear All Can anyone help me to write a formula. Please find attached sheet. Thanks in advance. -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poo

RE: $$Excel-Macros$$ Change Column Size

Try to zoom your worksheet Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mburkett Sent: 31 August 2012 11:41 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Change Column Size I am u

RE: $$Excel-Macros$$ Need update on the attached Macro

Hi Mohan, Thanks for your update. I couldn't find where to insert your code. Could you please insert your code 'If Target.Column <> Range("N1").Column Then Exit Sub' in my below code. so as I could run thru' quickly. Code:- Sub sendEmail() Dim objOL As Object Dim objMail As Objec

$$Excel-Macros$$ Gathering info from MySQL Bugzilla DB into Excel using VBA (is this even possible?)

If these questions have been answered elsewhere, the post is too long or you basically do not feel like reading it, please feel free to tell me so. I am typing it out, in hopes it helps someone. :-) In all seriousness though, let me say that learning MySQL, SQL Server, Perl, Apache, Bugzilla, w

Re: $$Excel-Macros$$ Change Column Size

>From his description, I think he's looking for something like >a SelectionChange Event. Where, when he selects the cell with the pull-down, it automatically changes the width of the column to ##. Then, when a different cell is selected, the column returns to it's original width.   Paul --

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

The "team" will be happier to help if you use a meaningful subject line and lose the URGENT!!! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: PRAVESH KUMAR Sent: Friday, August 31, 2012 1:09 PM To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi amresh, Thanks! for help me On 8/30/12, Amresh Maurya wrote: > Hi Pravesh, > > Find the attached solved file. > > =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) > > Reagrds > Amresh > > On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish < > vaishpriyanka2...@gmail.com> wrote: > >> Hi Pra

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] please help me to solve this question it's very urgent

Hi Noorain, Thanks a lot of ! search best to best solution. Thanks Pravesh On 8/30/12, NOORAIN ANSARI wrote: > Dear Pravesh, > > See attached sheet for more clarity. > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com

Re: $$Excel-Macros$$ Change Column Size

Have you looked at a SelectionChange event? You'd have to test to see if the target range is the cell you're trying to adjust.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times y

Re: $$Excel-Macros$$ Change Column Size

I need it to expand automatically when I select the cell and then return to original width after the cell is not selected. On Friday, August 31, 2012 2:15:08 PM UTC-4, NOORAIN ANSARI wrote: > > Dear Mburket, > > You can use.. > > > Sub column_fit() > Cells.Columns.AutoFit > End Sub > > On Fri, Au

Re: $$Excel-Macros$$ Change Column Size

Hi Mburket, Shortcut key: Alt+H+O+I use only Excel 2007, 2010, 2013 Preview. Regards, Kuldeep Singh On Fri, Aug 31, 2012 at 11:48 PM, NOORAIN ANSARI wrote: > Without VBa Code > you can use.. > > Alt+O+C+A > > > On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI > wrote: > >> Dear Mburket, >> >>

Re: $$Excel-Macros$$ Change Column Size

Without VBa Code you can use.. Alt+O+C+A On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI wrote: > Dear Mburket, > > You can use.. > > > Sub column_fit() > Cells.Columns.AutoFit > End Sub > > > On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote: > >> I am using a list with data validation in cells

Re: $$Excel-Macros$$ Change Column Size

Dear Mburket, You can use.. Sub column_fit() Cells.Columns.AutoFit End Sub On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote: > I am using a list with data validation in cells c64:c74. The choices are > very long text strings. Does anyone have code that will expand the column > width when I se

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Your most welcome. Regards, Kuldeep Singh On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR wrote: > Hi team, > > > Thanks so much for help me and give best to best Suggestions > > Thanks > Pravesh Kumar > > > On 8/30/12, Kuldeep Singh wrote: > > Dear Preavesh, > > > > 04 solutions

$$Excel-Macros$$ Change Column Size

I am using a list with data validation in cells c64:c74. The choices are very long text strings. Does anyone have code that will expand the column width when I select any of the cells and return to original (or specific) size once deselected? -- Join official facebook page of this forum @ htt

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh wrote: > Dear Preavesh, > > 04 solutions of you. for any query please see attachment. > > =LOOKUP(H3,$C$3:$D$9) > =VLOOKUP(H3:H6,$C$3:$D$9,2,0) > =VLOOKUP(H3,$C$3:$D$9,2,0) > =

$$Excel-Macros$$ Re: Transpose (Arr) problem with Dates

Thanks for the help On Thursday, August 30, 2012 6:57:37 PM UTC+1, RLM wrote: > > First post guys! > > I am trying to convert dates stored as text into proper formatted UK dates > DD/MM/. A sample spreadsheet is attached. The dates as text are > copied into a variant array, converted to a

$$Excel-Macros$$ Re: Combining variables with Excel Formulas

Perfect! Thank you for your help. On Friday, August 31, 2012 12:09:50 PM UTC-4, mburkett wrote: > > I have some code that is not working as I expected. I set a variable from > a value in a cell within the worksheet and add a countif formula. The > result I get in the cell is the variable along w

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

This is the message by microsoft just to inform to that your file contain macros. so either use .xls or .xlsm or .xlsb to save the file without message or just press yes to make it macro enable workbook. Regards, Lalit Mohan On Friday, 31 August 2012 13:28:23 UTC+2, Chidurala, Shrinivas wrote:

Re: $$Excel-Macros$$ Combining variables with Excel Formulas

Ojemeni Uzoma | Call 08060700717 -Original Message- From: Paul Schreiner Sender: excel-macros@googlegroups.com Date: Fri, 31 Aug 2012 10:04:52 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Combining variables with Excel Formulas Your result is exactly what

$$Excel-Macros$$ Re: Combining variables with Excel Formulas

I wish I could but it has proprietary data. Here is a little clarification The variable indname is set by going to a specific cell that has some text (exable below) Range("A1").Select indname = Selection.Value This sets the variable indname which is some text >From there I goto another cell whe

Re: $$Excel-Macros$$ Combining variables with Excel Formulas

Your result is exactly what you told Excel to do. when you put something in quotes ("), you're telling Excel to "take this string LITERALLY" and do not "evaluate" the string. So you basically said to set the cell value to the value of 'indname' and append a string. You might as well say: activec

$$Excel-Macros$$ Re: Need update on the attached Macro

Not in SendMail procedure just paste this line in worksheet_change event procedure from where you calling sendmail procedure Regards, Lalit Mohan On Friday, 31 August 2012 18:02:02 UTC+2, selva wrote: > > Hi All, > > > > Need an update on the attached macro file. Based on this file, whenever

RE: $$Excel-Macros$$ Need update on the attached Macro

Hi Mohan, Thanks for your update. I couldn’t find where to insert your code. Could you insert your code ‘If Target.Column <> Range("N1").Column Then Exit Sub’ in my below code. so as I could run thru quickly. Code:- Sub sendEmail() Dim objOL As Object Dim objMail As Object

$$Excel-Macros$$ Re: Combining variables with Excel Formulas

can you please attach file in which you want to do this to make it more understandable Regards, Lalit Mohan On Friday, 31 August 2012 18:09:50 UTC+2, mburkett wrote: > > I have some code that is not working as I expected. I set a variable from > a value in a cell within the worksheet and add a

Re: $$Excel-Macros$$ Need update on the attached Macro

Just use this line of code before calling sendmail procedure If Target.Column <> Range("N1").Column Then Exit Sub Hope it helps you Regards, Lalit Mohan On Fri, Aug 31, 2012 at 5:50 PM, Selva wrote: > Hi All, > > ** ** > > Need an update on the attached macro file. Based on this file, w

$$Excel-Macros$$ Combining variables with Excel Formulas

I have some code that is not working as I expected. I set a variable from a value in a cell within the worksheet and add a countif formula. The result I get in the cell is the variable along with the formula as written (as opposed to the result of the formula). Ideas? 'set variable indname = Se

Re: $$Excel-Macros$$ Number into hr:mm;ss

We don't really have enough information. hh:mm:ss is actually a TIME OF DAY display format. As you probably already know, Excel stores date and time as a number. the date is the number of days from 1/1/1900 (so 31-Aug-2012 is 41152) "time" is actually the fractional part of a day. at 6:00AM, 1/4

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

New to Excel 2010? There are new file formats for Excel files: .xlsx .xlsm .xlsb   .xlsx does not allow macros. The theory is that it is less likely to share an Excel macro-virus. So.. if you RECEIVE a file in .xlsx format, you can be assured that it is Missing Malicious Macros. .xlsm and .xlsb bo

Re: $$Excel-Macros$$ Required Revenue started from Date..

Don Sir, Nice Solution with excellent logic.. Kuldeep, you can also use vba version as UDF Function Get_RevenueDate(Rng As Excel.Range) Dim Cell As Range For Each Cell In Rng.Cells If Cell.Value > 0 Then Get_RevenueDate = Cells(1, Cell.Column).Value Exit Function End If Next End Function On

Re: $$Excel-Macros$$ Required Revenue started from Date..

This is an array formula that must be entered using ctrl+shift+enter =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV2>0,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kuldeep Singh Sent: Friday, August 31, 2012 7:35 AM To: excel-macros@googlegroups.com Subject: $$Ex

$$Excel-Macros$$ Pivot Table Vba Help needed

Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extra

Re: $$Excel-Macros$$ Required Revenue started from Date..

Dear Kuldeep, Please try it.. =INDEX($1:$1,0,SMALL(IF(D2:S2>0,COLUMN($D$1:$S$1),""),COLUMN($A$1))) with ctrl+shift+enter See attached sheet for more clarity. -- With Regards, Noorain Ansari http:// noorainansari.com http://

$$Excel-Macros$$ Number into hr:mm;ss

Hello, How to convert numbers into *day hh:mm:ss* Format based on any two dates. Thanks in advance. Regards, Chandru -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread

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

Dear Shrinivas, You are trying to save macro file in .xlsx extension. Please use extension .xlsm .xlsb or .xls On Fri, Aug 31, 2012 at 4:58 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > Dear All, > > ** ** > > I am face the attached Error in 2010 while saving active workb

Re: $$Excel-Macros$$ Need help

Dear Sriram, As we know in Excel 2003 Total rows are 65536 and total columns are 256 but in Excel 2007+ total rows are 1048576 and total columns are 16384. You need to take table array range A65536 and Column range 256, then vlookup function will working fine. Feel free to ask if you get any is

Re: $$Excel-Macros$$

Hi all, Thank you very much Regards, Chandra Shekar B On Fri, Aug 31, 2012 at 11:47 AM, NOORAIN ANSARI wrote: > Dear Chandra, > > Networkingdays is good solution for your query, but it doesn't work in > excel 2003. > > For excel 2003 you can use.. > > *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY(

Re: $$Excel-Macros$$ Need help

Dear Noorain.ansari, Thanks for your reply Noorain.ansarii have two excel files. one is 2003 excel file format and another one is 2007 excel file..when i did a vlookup 2007 excel file format to 2003 excel file format the error is came. Anyone can help me to resolve this problem... [image: Inl

$$Excel-Macros$$ Error in 2010

Dear All, I am face the attached Error in 2010 while saving active workbook on recording macro. [cid:image001.png@01CD8799.C70A4EE0] Regards, Shrinivas -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violati

Re: $$Excel-Macros$$ Outlook to excel VBA

Dear Noorin All VBA Experts, This is very Challenging work for me also you & Our other Excel users in group.I required VBA code when our research report published on outlook (Outlook 2003) then that report automatic save on give folder Path (H:\Published Reports\India Reports). So anyone put this

Re: $$Excel-Macros$$

Dear Chandra, In VBA Version you can also use.. Function GetWorkDays(ByVal StartDate As Long, ByVal EndDate As Long) Dim d As Long, dCount As Long For d = StartDate To EndDate If Weekday(d, vbMonday) < 6 Then dCount = dCount + 1 End If

Re: $$Excel-Macros$$ Outlook to excel VBA

Dear Moose, Please check below link, Hope it will help to you. http://www.jpsoftwaretech.com/working-with-the-outlook -recipients-collection-in-vba/ -- With Regards, Noorain Ansari http:// noorainansari.com http://

Re: $$Excel-Macros$$

Dear Chandra, Networkingdays is good solution for your query, but it doesn't work in excel 2003. For excel 2003 you can use.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<6))* if you want to exclude only sun then use.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(TODAY()&":"&B2)),2)<7))

RE: $$Excel-Macros$$ Need help

Reverse Vlookup, Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: 31 August 2012 13:24 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help Hi Noorain, Isna(vlookup) On Fri, Aug 31, 2012 at 1:16

Re: $$Excel-Macros$$ Need help

*Dear Sriram,* * * *Please write a meaning full subjects for e-mails.* * * *This will help us to search the mails anytime, based on the requirement.* * * *Thanks.* *Pravin* * * On Fri, Aug 31, 2012 at 12:22 PM, sriram ji wrote: > Dear Excel Guru, > > May I know how to vlookup 2003 Excel to 2007

Re: $$Excel-Macros$$

try =NETWORKDAYS formula Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:41 PM, अनिल नारायण गवली wrote: > try =NETWORKDAYS formula > > Thanks & Regards, > Gawli Anil > > On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello, >> I need a formul

Re: $$Excel-Macros$$

try =NETWORKDAYS formula Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > I need a formula for dates which excludes Saturday, Sunday & Holidays(in > sheet2). Could you please help with the formulas. > > Thanks in advan

Re: $$Excel-Macros$$ Need help

It would be grt to our group.. KIU. Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:24 PM, vijayajith VA wrote: > Hi Noorain, > > Isna(vlookup) > > > On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> If any have more example except it please share, we have

$$Excel-Macros$$

Hello, I need a formula for dates which excludes Saturday, Sunday & Holidays(in sheet2). Could you please help with the formulas. Thanks in advance. Regards, Chandra Shekar B -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members alrea

Re: $$Excel-Macros$$ Need help

Hi Noorain, Isna(vlookup) On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI wrote: > Dear Group, > > If any have more example except it please share, we have to make it for 50 > types. > > Please share if any one have examples... > > > > On Fri, Aug 31, 2012 at 1:07 PM,

Re: $$Excel-Macros$$ Need help

Dear Group, If any have more example except it please share, we have to make it for 50 types. Please share if any one have examples... On Fri, Aug 31, 2012 at 1:07 PM, NOORAIN ANSARI wrote: > Dear Sriram, > > I have created a Ebook of Vlookup (*Magic of Vlookup*), T

RE: $$Excel-Macros$$ Need help

Do you or anyone else have such detailed ebook or PPT on excel functions? If yes, please share. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 31 August 2012 13:07 To: excel-macros@googlegroups.com Subject: Re: $$E

RE: $$Excel-Macros$$ Need help

Wow.Noorain. This will be grt gift to this group members. Thanks a lot in Advance. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 31 August 2012 13:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macr

Re: $$Excel-Macros$$ Need help

Awesome.. On Aug 31, 2012, at 1:07 PM, NOORAIN ANSARI wrote: > Dear Sriram, > > I have created a Ebook of Vlookup (Magic of Vlookup), There are 35 types of > vlookup in it. > i will share shortly with group,this is because some design part is still > pending. > > See a Snap shot > > Sr.N

Re: $$Excel-Macros$$ Need help

Dear Sriram, I have created a Ebook of Vlookup (*Magic of Vlookup*), There are 35 types of vlookup in it. i will share shortly with group,this is because some design part is still pending. See a Snap shot *Sr.No* *Types of Vlookup* *Status* *1* *Simple Vlookup* *Yes* *2* * Vlookup+Mat

Re: $$Excel-Macros$$ Need help

Hi, More examples in below websites. for any query please share a worksheet with Group. http://chandoo.org/wp/2010/11/02/excel-vlookup-tips/ http://www.techonthenet.com/excel/formulas/vlookup.php http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx Regards, Kuldeep Singh On F

Re: $$Excel-Macros$$ Need help

Dear Sriram Attached is the Eg of Vlookup furmulae Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 12:26 PM, pankaj sangotra wrote: > Hi Sriram, > > Vlookup is used to pick values from tables for lookup values... > > For more details use techonthenet.com.. This is an awesome website.. If