Re: $$Excel-Macros$$ Re: Help On Print

attach or send me your file with a better explanation and examples. Don Guillett SalesAid Software dguille...@gmail.com From: Shrinivas Shevde Sent: Friday, December 16, 2011 10:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Help On Print Dear Rohan Thanks for the

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Ofcorse it can hve macros, the idea behind it to store invoice data. If macros is being used then to make it more good other then active sheet can be hiden. Vickey -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Dear Aamir, Thanks... *=VLOOKUP(D7,INDIRECT(TEXT(D5,)!B2:C4),2,FALSE)* in above formula Indirect function is providing us full month name which are also sheetname. after using indirect function range is converting like October!B2:C2,November!B2:C2,December!B2:C2, which is our

Re: $$Excel-Macros$$ regarding addins in vba

pfa 2011/12/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Vijay, Please try it file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm http://www.ozgrid.com/Services/ExcelAdd-insPage.htm -- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ regarding addins in vba

Thanks Noorain On Sat, Dec 17, 2011 at 11:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: pfa 2011/12/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Vijay, Please try it file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm http://www.ozgrid.com/Services/ExcelAdd-insPage.htm

Re: $$Excel-Macros$$ regarding addins in vba

Noorain sb, What about excel 2010 add in , if I want to create one add in (password protected) where I can save all desired macros, UDF if any buttons for create customized commands. Regards, Aamir Shahzad On Sat, Dec 17, 2011 at 11:10 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: pfa

$$Excel-Macros$$ Mid Function

Dear Group, When I am extracting the Insulators text by below mentioned mid function it shows only Insulat, Please suggest what amendment required in this formula. Ceramic Insulators #124-TD45-87 =MID(A2,FIND( ,A2),FIND( ,A2)) -- Regards, Aamir Shahzad -- FORUM RULES (934+ members already

RE: $$Excel-Macros$$ Mid Function

Hello Aamir, You can use: =MID(A2,FIND( ,A2)+1,FIND( ,A2,FIND( ,A2)+1)-FIND( ,A2)) Because the third argument to MID is the starting position, we can start the search for the second space after the first space. ~Asa From: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Mid Function

Thanks Asa Aamir Shahzad On Sun, Dec 18, 2011 at 12:36 AM, Asa Rossoff a...@lovetour.info wrote: Hello Aamir, You can use: =MID(A2,FIND( ,A2)+1,FIND( ,A2,FIND( ,A2)+1)-FIND( ,A2)) Because the third argument to MID is the starting position, we can start the search for the second space

Re: $$Excel-Macros$$ Median in Pivot Table

Hi Noorain, Thanks for your response but I am disappoint to know that we cannot make user define function within Pivot -- Atul On Thu, Dec 15, 2011 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Atul, Please see below link, hope it will help to u.

$$Excel-Macros$$ help to make pivot table

plzz tell me how to make a pivot table -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

Re: $$Excel-Macros$$ Mid Function

Try the following formula: =IF(ISERR(MID(A2,FIND( ,A2)+1,IF(ISERR(FIND( ,A2,FIND( ,A2)+1)), FIND( ,A2),FIND( ,A2,FIND( ,A2)+1))-FIND( ,A2)-1)),,MID(A2,FIND( ,A2)+ 1,IF(ISERR(FIND( ,A2,FIND( ,A2)+1)),FIND( ,A2),FIND( ,A2,FIND( ,A2)+1))-FIND( ,A2)-1)) Norman On Sat, Dec 17, 2011 at 2:03 PM, Aamir

Re: $$Excel-Macros$$ Almost all calculator in one sheet

thanx ankit, this is awesome. and quite usefull. On Thu, Dec 1, 2011 at 9:45 AM, Pranav N nadab...@gmail.com wrote: Thanks. -Nas On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Hello All, In our daily life we calculate so many thing use

$$Excel-Macros$$ Worksheet Combobox to list available macro

Hi, Does someone know how to list macros from current opened workbooks in a worksheet control combobox? More precisely, I'd like to make a reference or create an alias to a macro. For instance: in the project window in the Vba editor in another OPENED workbook I have a few macros like :

$$Excel-Macros$$ Compare character types in 2 character string

I have extracted 2 characters from a longer string. I need to determine if both characters are the same type (both alphabetic, or both numeric), else if they are a different character types. The order of character types does not matter, just if they are both the same type. Please correct my terms

$$Excel-Macros$$ Help on isblank iferror

Hi All, I want to put isblank and iferror formula in one cell. Can you please help. Attached sheet for your reference. Regards, Vijayendra 94491 67631 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ VBA select data in BOLD

Hi Don Noorain Thanks for your comments and ideas. I am taking one of our address lists and reducing the information in it as we will be doing everything by email and phone. Address etc not now required. Will also once this first task finished then classify into Catergory types for industries

Re: $$Excel-Macros$$ help to make pivot table

http://www.contextures.com/xlpivot01.html http://www.contextures.com/xlpivot04.html http://www.contextures.com/tiptech.html On Sat, Dec 17, 2011 at 9:46 AM, Ruchi Sharma simpliru...@gmail.com wrote: plzz tell me how to make a pivot table -- FORUM RULES (934+ members already BANNED for

Re: $$Excel-Macros$$ Need a macro to update charts automatically

Please explain your need Don Guillett SalesAid Software dguille...@gmail.com From: Atul vishwakarma Sent: Thursday, December 15, 2011 8:29 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Need a macro to update charts automatically Hi Friends, I need a macro to update charts

Re: $$Excel-Macros$$ Help on isblank iferror

=IF(A3=,,IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),not recieved)) Don Guillett SalesAid Software dguille...@gmail.com From: Vijayendra Rao Sent: Friday, December 16, 2011 6:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on isblank iferror Hi All, I want to put isblank and

Re: $$Excel-Macros$$ Help on isblank iferror

as desired =IF(ISBLANK(A2),,IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$3,1,0)),Not Received,SUMIF(Sheet1!$A$2:$A$3,A2,Sheet1!$B$2:$B$3))) See the attached sheet. Aamir Shahzad On Fri, Dec 16, 2011 at 5:44 PM, Vijayendra Rao vijayendrar...@gmail.comwrote: Hi All, I want to put isblank and iferror

Re: $$Excel-Macros$$ Mid Function

Hello Amir, you can use below formula as well. =LEFT(MID(A2,FIND( ,A2)+1,FIND( ,A2,FIND( ,A2)+1)),FIND( ,MID(A2,FIND( ,A2)+1,FIND( ,A2,FIND( ,A2)+1 but i think below formula is much shorter than this 1.  :) From: Aamir Shahzad aamirshahza...@gmail.com

RE: $$Excel-Macros$$ urgent,can anyone teach me Private Const LLKHF_ALTDOWN = H20 meaning

Hi Garcia, The key words and symbols in that line of code have the folowing meanings: PRIVATE - Scope of the constant is limited to the current module. Other modules cannot access the constant. CONST - Define/declare a constant (like a variable, but the value cannot be modified. It has a

RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM, =isnumber(left(a1,1))=isnumber(right(a1,1)) That will return TRUE if the first and last character are the same type (numeric or non-numeric). It will return FALSE if they are different types. Asa -Original Message- From: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM, Sorry, correction: =ISERROR(VALUE(LEFT(A1,1)))=ISERROR(VALUE(RIGHT(A1,1))) is the correct formula for the below! :) Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Saturday, December 17, 2011

Re: $$Excel-Macros$$ VBA select data in BOLD

On Sun, Dec 18, 2011 at 9:18 AM, dguillett1 dguille...@gmail.com wrote: Attached wbook Hi Don This happens when I run the code- Highlights *SearchFormat:=* with msg: Compile error Named argument not found r1 = Range(Cells(1, g), Cells(lr, g)).Find(What:=, After:=Cells(sr, G),

Re: $$Excel-Macros$$ VBA select data in BOLD

Did you run it on the file I sent you? I just retested xl2003, xl2007, xl2010 and it worked just fine on all. Send YOUR file. Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Saturday, December 17, 2011 6:17 PM To: excel-macros@googlegroups.com Subject: Re:

$$Excel-Macros$$ shortcut key .

Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

Re: $$Excel-Macros$$ shortcut key .

Hi Try this: http://dmcritchie.mvps.org/excel/shortx2k.htm Cheers, andy On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for

Re: $$Excel-Macros$$ shortcut key .

HI andy, A Filter button [image: Applied filter icon] means that a filter is applied.-I want to clear ths applied filter .for that i need short cut key .i refered your link. i dint get it please hlp me Thanks for your reply On Sun, Dec 18, 2011 at 10:55 AM, Aindril De aind...@gmail.com wrote:

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for

Re: $$Excel-Macros$$ shortcut key .

Sorry . that is for put filter and remove filter.i need to clear checked items .in filtered coloumn. On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41

Re: $$Excel-Macros$$ shortcut key .

The same is applicable for removing filter also. --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA vijayajith...@gmail.comwrote: Sorry . that is for put filter and remove filter.i need to clear checked items .in filtered coloumn.