Re: $$Excel-Macros$$ Need a small help

Thanks Don. On Mon, Mar 12, 2012 at 2:38 AM, dguillett1 wrote: > try custom format of > > h > or > [$-409]h;@ > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Indrajit $nai > *Sent:* Sunday, March 11, 2012 3:52 PM > *To:* excel-macros@googleg

Re: $$Excel-Macros$$ Error in condition of particular data receive from another sheet

Thanks saurabh for attention of error but there is not time problem, there are no error occurred and also result not display in the cell, if you find the data without error, please send me a attachment sheet with successful working of formula. Thanks & regards Ashish Bhalara On Sat, Mar 10, 2012

RE: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

Thanx Rajan for suggesting, I will try as u said. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Sunday, March 11, 2012 6:17 PM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Syntax used in VBA

Hi dnkndnkn, For beginners, I would suggest following:- 1) Do short recordings for each and every step (frequent used would be better), press Alt + F11 and see how Excel has transferred those actions (steps) into VBA syntax. Now type / edit them and run the code to see the changes and you will le

Re: $$Excel-Macros$$ Help Formula to find last date please

Hi Marcio, It has been done using Excel formula, see the attachment and let me know if this is what you were looking for. Feel free to get back in case of any queries. Thanks. Regards, DILIPandey On Mon, Mar 12, 2012 at 6:53 AM, Marcio Bandeira de Azevedo < marciobandeir...@gmail.com> wrote:

RE: $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide

Hi Rekha, You can change the line that sets the vertical position from: newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = 80 to this (one line): newPowerPoint.ActiveWindow.Selection.ShapeRange.Top = newPowerPoint.ActivePresentation.PageSetup.SlideHeight - newPowerPoint.ActiveWindow.Selectio

RE: $$Excel-Macros$$ Add business address in a single row

Hello Lokesh, If you provide a sample file your requirement will be clearer. Are you importing a number of addresses from a text file? If it is just one address you might like the option of simply using the & concatenation operator or the concatenate function (I always use &) like so: =A1&",

RE: $$Excel-Macros$$ Query

No main will ever be > than maximum main of course, but it will save calculation time. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, March 11, 2012 10:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query

Re: $$Excel-Macros$$ Need a small help

try custom format of h or [$-409]h;@ Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Sunday, March 11, 2012 3:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small help Hi All, Need a small help, can anyone convert th

$$Excel-Macros$$ Syntax used in VBA

The syntax of VBA is different than other languages. It is difficult to remember the syntax, There are many different ways to achive same task. It becomes confusing for a beginner. Please suggest a way to master syntax. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation

$$Excel-Macros$$ Need a small help

Hi All, Need a small help, can anyone convert the below mention format into the Hour? 3/12/2012 2:21 Should be only 2. Is there any formula? if its present then please provide me the same. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are

$$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide

Greetings to one and all, please provide a vba code for copying text frame from excel and to paste in bottom of power point slide. i have macro code in attached note pad in which macro pastes the text frame on right hand side of slide but can any one provide code to paste text frame in bottom

Re: $$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

Hi you can do it by using web queryor recording it or You can download sample workbook from below link. http://www.marketcalls.in/spreadsheet/vba-macro-to-download-bhavcopy.html HTH Mahesh On Sun, Mar 11, 2012 at 1:50 PM, rajeyssh wrote: > will y

Re: $$Excel-Macros$$ Add business address in a single row

Hi You can use CONCATENATE attach sample workbook if you are looking something different. HTH Mahesh On Sun, Mar 11, 2012 at 8:11 PM, Lokesh Loki wrote: > Hi Experts, > > > I need to add these business addresses in a single row, so could you > please provide me a formula so that I can do furthe

Re: $$Excel-Macros$$ Basics of excel & vba -plz send

Hi check this http://groups.google.com/group/excel-macros/browse_thread/thread/d23c567bf291be61/c79f558a40407eee?q=#c79f558a40407eee HTH Mahesh On Sat, Mar 10, 2012 at 10:55 PM, Anil Kumar wrote: > Hi Dear members, > > I am new to this group. > > > thnx in adv. > > -- > FORUM RULES (986+ memb

Re: $$Excel-Macros$$ Query

Asa, My formula tested fine without the proposed change. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Sunday, March 11, 2012 11:28 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Query Hi Aamir, You're welcome. The "max

Re: $$Excel-Macros$$ how to make a sub with arrays parameters

thanks Asa, i'll investigate more...:) On Mar 10, 9:30 am, "Asa Rossoff" wrote: > bpascal, > > > Dim Comp() As String > > Dim PartR() As String > > > So the sub would be: > > call BellyDance(CompBis(), PartBis(), wksA, wksB, wksC) > > or > > BellyDance CompBis(), PartBis(), wksA, wksB, wksC > > A

RE: $$Excel-Macros$$ Query

Hi Aamir, You're welcome. The "maximum" version does that. Array enter on row 2 and copy down. =IF($C2<>"MAIN",IF($B2>MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16="MAIN"),$B$2:$B$1 6)),"Greater than Main",""),"") Don's sumproduct version should work too; to calculate his formula only for non-main

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

Sheet protection easy to defeat while vba protection is more difficult. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Seraj Alam Sent: Sunday, March 11, 2012 10:01 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help... Hi, Please find below

RE: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

It's a pre posted solution Ok.. Its an add-ins which can take input from multiple worksheets within a workbook .. when you will press shift+ctrl+P a dialogue box will open to take input ranges you can add multiple range (All range should have same format and no column should have blank head

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

Hi, Please find below link to hide formula in spreadsheets... http://www.techonthenet.com/excel/cells/hide_formulas.php Thanks Seraj On Sun, Mar 11, 2012 at 4:57 PM, ashjain2...@yahoo.co.in < ashjain2...@yahoo.co.in> wrote: > Dear Team > > I use many formulas in the excel sheet and i want th

$$Excel-Macros$$ Add business address in a single row

Hi Experts, I need to add these business addresses in a single row, so could you please provide me a formula so that I can do further needful action. *Example :- **Shapers Hair Salon & Spa, 27- 565 Bernard Ave., Kelowna, British Columbia, V1Y 8R4, Kelowna, NULL* ** Name:Shapers Hair Sal

Re: $$Excel-Macros$$ Query

=IF(B2>SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31="main","Greater than Main","") Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Sunday, March 11, 2012 1:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Quer

Re: $$Excel-Macros$$ need VBA Code plz help

Have you tried using data>filter>autofilter>> Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Gulam Hameed Sent: Sunday, March 11, 2012 1:13 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ need VBA Code plz help Dear Noorain & experts I wa

Re: $$Excel-Macros$$ Help: VBA code for RGB values

https://www.google.com/webhp?rlz=1C1ARAA_enUS430US430&sourceid=chrome-instant&ie=UTF-8&ion=1#hl=en&rlz=1C1ARAA_enUS430US430&sclient=psy-ab&q=excel%3Aconditional%20formatting%20pivot&oq=&aq=&aqi=&aql=&gs_sm=&gs_upl=&gs_l=&pbx=1&fp=190a38aff74067d&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=10

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

My preference would be to use macros to input the resulting value using vba or application.sum or EVALUATE. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ashjain2...@yahoo.co.in Sent: Sunday, March 11, 2012 6:27 AM To: excel-macros@

Re: $$Excel-Macros$$ Query

=IF(B2>SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31="main","Greater than Main","") Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, March 10, 2012 11:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query

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

Hi, 1. Hit Ctrl + A -> Ctrl + 1 -> Protection -> Uncheck Locked -> OK. 2. Hit F5 -> Special -> Check Formulas -> OK. Repeat the 1st step and check Locked as well as Hidden. Now protect the sheet. Kris On Sunday, 11 March 2012 16:57:34 UTC+5:30, ashja...@yahoo.co.in wrote: > > Dear Team > >

$$Excel-Macros$$ Help...

Dear Team I use many formulas in the excel sheet and i want that no one can see the formulas... Request you to please suggest how to lock it.. Ashok - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

Please find below link for how to creat pivot table on multiple sheet... http://www.youtube.com/watch?v=ZBn1-r0I5oE On Sat, Mar 10, 2012 at 10:40 AM, Mohammed Muneer wrote: > Dear Group Plz, tell me how I can use it? And for what purpose? > > ** ** > > ** ** > > Regards, > > Muneer,***

$$Excel-Macros$$ Spread sheet for NSE, BSE, MCX or all Indian exchange data.

will you help me by telling me how can i make spreadsheet for the data. i am attaching the link of bhav copy and want to save day by day data in the spreadsheet. If any body in this group already have it and want to share it, welcome. http://www.mcxindia.com/SitePages/BhavCopy.aspx -- FORUM RULES