Re: $$Excel-Macros$$ Help Needed on Index

You can't have an Excel function replace the values in the cell.You could use VBA, but it would be easier to simply use VLOOKUP. In Cell B21, put:=VLOOKUP(C21,$A$10:$B$17,2,FALSE)Then copy this down to row 29. HIghlight the cells and ctrl-CThen, right-click cell C21 and Paste Values.  Paul

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Mr. Shot: :) I don't believe you're being "ignored".I suspect it's more along the lines of:"How much effort do I/we have to put into trying to figure out what it is you want to do and do I/we have the expertise to address it". Your messages are a "little" confusing. You've posted a question on an

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Hi Guys, Still waiting for some resolution in this group. Pls help. On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote: > Dear Experts, > > I want help in macro which can attach 4 mail with standard subject line > into one mail as an attachment and send that mail to a particular distor > list

Re: $$Excel-Macros$$ Help needed in Macro to send mails

Hi Guys, Cant anyone here help me pls. Does no one know OUTLOOK MACROS On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote: > Dear Experts, > > I want help in macro which can attach 4 mail with standard subject line > into one mail as an attachment and send that mail to a particular distor > li

Re: $$Excel-Macros$$ Help needed

Use Data==> Filter to get non zero values... On Wed, Mar 11, 2015 at 1:34 PM, Harish P Y wrote: > Hi, > > Needed help with the file attached file.I want to get the data of only the > non zero elements from abstract sheet to abstract 2 sheet. > kindly help me in this regard. tried pivot table but

Re: $$Excel-Macros$$ Help Needed

Dear Paul, Thank you same as working properly. Thanks & Regards, Sriram. On Tue, Nov 25, 2014 at 5:04 PM, Paul Schreiner wrote: > Do you mean like: > =IF(AND(C5>1.1,C8>1.1),0.8,C10/C4) > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the m

Re: $$Excel-Macros$$ Help Needed

Do you mean like: =IF(AND(C5>1.1,C8>1.1),0.8,C10/C4) 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 you can, To all the people you can, As long as ever you can.” - John Wesley -

Re: $$Excel-Macros$$ Help needed

Hi Ravinder, PFA Regards Ashish On Sun Nov 16 2014 at 5:10:24 PM Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi All, > > Please help me in the attached data, please share also the way to resolve > it. > > Regards, > Ravindra > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi, Check this one! Regards Ashish -- 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,

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi, Check this..!! Regards Ashish -- 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, lik

Re: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart

Hi Amit, PFA..!!! Regards Ashish Kumar On 24 September 2014 16:22, Amit Desai (MERU) wrote: > Dear All, > > > > I would like to have a layered chart for 3 cities...So for each city there > should be 3 main bars. These each Bar has to have 2 sub bars in side it... > > > > So for Mumb

Re: $$Excel-Macros$$ Help Needed

Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah wrote: > fyi > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > > > On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar > wrote: > >> Hi Guys, >>

Re: $$Excel-Macros$$ Help Needed

fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar wrote: > Hi Guys, > > I want to use formula on pivot table data. > > Kindly help me. > > > -- > Thanks £ Regards > Rakesh Kumar > +91-9650303464 > > > > -- > Are yo

Re: $$Excel-Macros$$ Help Needed

Dear, use this. =num2text(reference) Please check attachment. thanking you On 4 February 2014 09:42, Harish P Y wrote: > It is not working Sir > > > With Regards > > *HARISH P Y* > > *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether > it is really necessary. Thanks for yo

Re: $$Excel-Macros$$ Help Needed

It is not working Sir With Regards *HARISH P Y* *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future generation* *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3 shee

Re: $$Excel-Macros$$ Help Needed

Dear Harish, Please find attachment of addin. Please use & reply. Thanking you (it was received by me in 2009 through this group) On 30 January 2014 14:39, Harish P Y wrote: > Dear Excel Gurus, > > Please find the attached file Marks Sheet, > and i want to obtain the marks obtained in words a

Re: $$Excel-Macros$$ Help Needed

This is very useful. > http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html > Thanks for this Link. -- 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 f

Re: $$Excel-Macros$$ Help Needed

http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html http://support.microsoft.com/kb/213360 http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html check above links On Thu, Jan 30, 2014 at 2:39 PM, Harish P Y wrote: > Dear Excel Gurus, > > Please f

Re: $$Excel-Macros$$ Help needed

Ravinder, PFA, Regards, Cartik On Tue, Nov 12, 2013 at 10:50 AM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > Please help me, to create a formula with small function and Vlook up > function. > > > Regards > Ravindra > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

Hi I have attached some dummy data. Please suggest how can I calculate on year basis or division basis like if I change the division to calculate the head count/CTC then data should change automatically. In HR Dashboard I can show the status of recruitment done/ Exits/Head Count in a particular

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/

RE: $$Excel-Macros$$ Help needed in creating a Dashbord

Give some data...in which you want to work even dummy data. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of alisha malhotra Sent: Tuesday, October 15, 2013 11:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed in creating a Dash

Re: $$Excel-Macros$$ Help needed in Excel

.com >> *Cc:* ravinder negi >> *Sent:* Tuesday, August 13, 2013 8:49 AM >> *Subject:* Re: $$Excel-Macros$$ Help needed in Excel >> >> >> I want to merge contents of column A & B as shown in column C. Please see >> the sample file e

Re: $$Excel-Macros$$ help needed urgent

thanks.. its done On Wed, Aug 21, 2013 at 4:05 PM, vba wrote: > See any hidden temp file is created or not. > > Try revoking shared access for particular folder n re share. > > Thanks > On 21 Aug 2013 17:26, "thameem" wrote: > >> Dear all, >> file is in server, but no one is using that file, b

Re: $$Excel-Macros$$ help needed urgent

See any hidden temp file is created or not. Try revoking shared access for particular folder n re share. Thanks On 21 Aug 2013 17:26, "thameem" wrote: > Dear all, > file is in server, but no one is using that file, but stil showing file is > use.. please help me wat to do... > > -- > Are you =E

Re: $$Excel-Macros$$ Help needed in Excel

roups.com > *Cc:* ravinder negi > > *Sent:* Tuesday, August 13, 2013 8:49 AM > *Subject:* Re: $$Excel-Macros$$ Help needed in Excel > > > I want to merge contents of column A & B as shown in column C. Please see > the sample file enclosed > > > On Wednesday,

Re: $$Excel-Macros$$ Help needed in Excel

I want to merge contents of column A & B as shown in column C. Please see the sample file enclosed On Wednesday, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote: > > pls provide excel or explain more about your query... > > -- > *From:* Pankaj > > *To:* ex

Re: $$Excel-Macros$$ Help needed in Excel

pls provide excel or explain more about your query... From: Pankaj To: excel-macros@googlegroups.com Sent: Wednesday, August 7, 2013 9:23 AM Subject: $$Excel-Macros$$ Help needed in Excel I have 2 columns in excel - A and B. I want to merge the contents

Re: $$Excel-Macros$$ Help needed in Excel

Concatenate(a1,char(10),b1) On Aug 7, 2013 9:24 AM, "Pankaj" wrote: > > > I have 2 columns in excel - A and B. > > I want to merge the contents of a horizontal row one below the other as: > A > B > > please tell me a formula to do this as the columns contain 900 cells each > and I cannnot merge t

Re: $$Excel-Macros$$ Help needed

thank you it working On Sun, Jul 14, 2013 at 3:58 PM, ashish koul wrote: > try this > Sub check_files_to_open() > > Dim flname As String > > flname = InputBox("Enter file to search") > Set fso = CreateObject("scripting.filesystemobject") > Set fld = fso.getfolder("C:\Users\admin

Re: $$Excel-Macros$$ Help needed

try this Sub check_files_to_open() Dim flname As String flname = InputBox("Enter file to search") Set fso = CreateObject("scripting.filesystemobject") Set fld = fso.getfolder("C:\Users\admin\Desktop\New folder") For Each fil In fld.Files If UCase(Left(fil.Name, InStrR

Re: $$Excel-Macros$$ Help needed

sorry again not working, its asking to select folder, later file name, if i type file name, its actually pdf format but opening in excel format. cant we fix folder path in this program, so there is no need to select folder every time On Sun, Jul 14, 2013 at 11:57 AM, ashish koul wrote: > hi

Re: $$Excel-Macros$$ Help needed

hi try this Sub check_files_to_open() Dim fldpath Dim fld As Object, fil As Object, fso As Object Dim flname As String With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With flname = InputBox("Enter file to search") On Error Resume Next fldpath = App

Re: $$Excel-Macros$$ Help needed

Sorry, might be I am not explained clearly, example I have file name "350" in that folder i have file names from 1 to 5000, i will type this file name "350" in one cell, then i will run vba code, so it can open file with name "350". please help me regards, thameem On Sun, Jul 14, 2013 at 9:57 A

Re: $$Excel-Macros$$ Help needed

try this see if it helps Sub check_files_to_open() Dim fldpath Dim fld As Object, fil As Object, fso As Object With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With On Error Resume Next fldpath = Application.FileDialog(msoFileDialogFolderPicker).Sel

Re: $$Excel-Macros$$ Help Needed

HI DP many thanks for the solution..for my query and its working and serving my purpose 100% thanks Patil M G On Wed, Jul 10, 2013 at 7:22 PM, De Premor wrote: > Hi Patil, > > PFA > > Please Run Procedure named *GenerateFromTemplate > * > Rgds, > [dp]* > > * > Pada 10/07/2013 18:30, Pati

Re: $$Excel-Macros$$ help needed

Thank you Sir, lock aspect ratio and move and don't resize with cells, are not checked(ticked), I did both. thank you once again for helping me, regards, Thameem.M On Mon, Jun 10, 2013 at 8:38 AM, P.VIJAYKUMAR wrote: > Respected Thameem, > > After inserting the graph you get the chart tools in

Re: $$Excel-Macros$$ help needed

Respected Thameem, After inserting the graph you get the chart tools in the menu bar. In the chart tools menu go to the formatting tab. In the last tab (to the right) you will find size munu.Click the small arrow down the tab and you will get sizing message box with size and properties tabs.In the

Re: $$Excel-Macros$$ help needed

am sorry, it is office file, I am working for gas plant, they dont allow us to use USB or to upload any official file in mail. regards, Thameem.M On Sun, Jun 9, 2013 at 1:56 PM, priti verma wrote: > Can you please share your file > > > On Sun, Jun 9, 2013 at 2:32 PM, thameem wrote: > >> Dear s

Re: $$Excel-Macros$$ help needed

Can you please share your file On Sun, Jun 9, 2013 at 2:32 PM, thameem wrote: > Dear sir's, > > I have problem in excel graph, its automatically getting enlarged, if i > close and open excel, then again it will be in original size, with out any > modification, please advise me > > > regards, >

Re: $$Excel-Macros$$ Help Needed

its serving my requirement..thank you so much for help paul thanks Patil MG On Wed, Jun 5, 2013 at 8:05 PM, Paul Schreiner wrote: > Try this macro. > > if it does what you're looking for, then I can walk you through how it > operates. > > > *Paul* > > ---

Re: $$Excel-Macros$$ Help Needed

oh yeah its working.. thanks abhi... :D regards Prabhu R On 15 May 2013 10:49, Abhishek Jain wrote: > Whenever you add, delete, or rename a sheet - just save and close the > file. When you will open the file again, it will be updated. > > > On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky

Re: $$Excel-Macros$$ Help Needed

Whenever you add, delete, or rename a sheet - just save and close the file. When you will open the file again, it will be updated. On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky wrote: > Hi abhi, > > thanks for your quick help. it really works fine. > > i need one more modification in this querr

Re: $$Excel-Macros$$ Help Needed

Hi abhi, thanks for your quick help. it really works fine. i need one more modification in this querry. is it possible if i delete any sheet in this workbook and it should not show in that list..? On 15 May 2013 10:36, Abhishek Jain wrote: > You did not mention that in your earlier query. >

Re: $$Excel-Macros$$ Help Needed

You did not mention that in your earlier query. However, attached is the solution to your new requirement. Regards, Abhi On Wed, May 15, 2013 at 10:22 AM, Prabhu Pinky wrote: > thanks abhi, > > but i need this to be listed in drop down menu. > > > regards > prabhu r > > > On 15 May 2013 10:19,

Re: $$Excel-Macros$$ Help Needed

thanks abhi, but i need this to be listed in drop down menu. regards prabhu r On 15 May 2013 10:19, Abhishek Jain wrote: > Here. > > This will create a list downwards from the selected cell. > > On the Home sheet, select A1 and click the button. If you change the name > of sheets, or add / re

Re: $$Excel-Macros$$ Help Needed

Here. This will create a list downwards from the selected cell. On the Home sheet, select A1 and click the button. If you change the name of sheets, or add / remove sheets, click on the button again to update. HTH Regards, On Wed, May 15, 2013 at 10:04 AM, Prabhu Pinky wrote: > Hi experts, >

Re: $$Excel-Macros$$ Help needed

Thank You very much for prompt response! On Thu, Apr 11, 2013 at 10:22 PM, ashish koul wrote: > =MID(A1,FIND(5,A1),6) > > > > On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA > wrote: > >> Hi Team, >> >> I need a formula to find anything starting from 5 in a cell and to take 6 >> digit right of

Re: $$Excel-Macros$$ Help needed

=MID(A1,FIND(5,A1),6) On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA wrote: > Hi Team, > > I need a formula to find anything starting from 5 in a cell and to take 6 > digit right of the cell starting from 5 as below. > > Eg. > > DataDesired Result > ABC 500012 XYZ

Re: $$Excel-Macros$$ Help needed to write For/End loop using Range statement ...

There are several different types of loops. The type you select will depend on your specific situation. a couple of examples would be: '--- Sub Loop1()     Dim Rng As Range     For Each Rng In Range("A2:A10")     MsgBox Rng.Value     Next Rng

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi, Here is another solution without inserting exta column "Column D". Don't ask me to explain this formula, because I also don't know how it works. [?] I get this formula from net and just modified it. Following is the link from where I get it. http://www.excelforum.com/excel-formulas-and-funct

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi, Pls find attached excel. Check if it is ok with you. Regards, Swapnil. On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka wrote: > Hi all, > > thank you all for your help and time that you spend to solve this problem! > I am very happy with the solution that Ashish attached. > > This solut

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi all, thank you all for your help and time that you spend to solve this problem! I am very happy with the solution that Ashish attached. This solution works perfect and I am very happy with it - thank you! Unfortunately, I forgot to mention something important yesterday ... I need this fu

Re: $$Excel-Macros$$ Help needed to create a function within a macro

see the attachment check the cells with "Yellow" color On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande wrote: > Hi, > > Insert followibg formula in D1 cell. > > =if(and(or(a1=1,b1=1),c1>23400),3,0) > > Hope this is what u want. > > Regards > > swapnil, > On Oct 9, 2012 6:57 PM, "Henning Deschk

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c1>23400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM, "Henning Deschka" wrote: > Hi NG, > > I need to insert a function into cell D1 with an Excel2007 macro that > executes the following: > >

Re: $$Excel-Macros$$ Help needed in sum

Thank you its working On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya wrote: > Hi Rambabu, > > Find the attached file. > > use this formula. > > =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15) > > Regards > Amresh > > > > > On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI > wrote: > >> Please try >>

Re: $$Excel-Macros$$ Help needed in sum

Hi Rambabu, Find the attached file. use this formula. =SUMIFS(I15:I24,K15:K24,"<"&O15,J15:J24,N15) Regards Amresh On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote: > Please try > > =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) > > > On Mon, Sep 3, 2012 at 5:17 PM, Rambabu

Re: $$Excel-Macros$$ Help needed in sum

Dear Ram, If you working in prior version of Excel 2007 You can use =SUMPRODUCT(($J$15:$J$24=N15)*($K$15:$K$24<=O15)*($I$15:$I$24)) On Mon, Sep 3, 2012 at 5:19 PM, NOORAIN ANSARI wrote: > Please try > > =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) > > > On Mon, Sep 3, 2012 at 5:17

Re: $$Excel-Macros$$ Help needed in sum

Please try =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,"<="&O15) On Mon, Sep 3, 2012 at 5:17 PM, Rambabu Mudiraj wrote: > Dear all, > > > -- > Regards > Rambabu. G > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members alre

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

Dear Sanotsh, If you are using Excel 2007+, Attached sheet will also helpful for you. On Sat, Jul 21, 2012 at 4:38 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > > Hi Group, > > Need another help to count and sum data between two fixed dates. > > > Regards > Santosh > santoshkuma

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: santosh subudhi Sent: Saturday, July 21, 2012 6:08 AM To: excel-macros Subject: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates. Hi Group, Need another help to count and sum data

RE: $$Excel-Macros$$ help needed - VBA

You can try this : Sub sauce_data_FRI_AMPM() Dim wbkNew As Workbook Set wbkNew = Workbooks.Open(Filename:="R:\Planning\Sauce Plan - New.xls", ReadOnly:=True) wbkNew.Worksheets("SaucePlan").Range("E6:H101").Copy Workbooks("LowRisk EPlan SAUCE week 19.xls").Worksheets("YourSheetName").Rang

Re: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

Please download ; http://www.minipdf.com/ I tried it and it works fine ... Chilexcel 2012/4/20 Rajan_Verma > I think No, you can’t change. > > ** ** > > You can convert it in PDF and make it readable by One Adobe Tools [name I > don’t remember) , Please google it. > > ** ** > > Ra

RE: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

I think No, you can't change. You can convert it in PDF and make it readable by One Adobe Tools [name I don't remember) , Please google it. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shekhar Sharma Sent: Apr/Fri/2012 02:32 To: excel-macro

Re: $$Excel-Macros$$ Help Needed

Try this Sub CreateWordDocs() Dim xsht As Worksheet Dim rng As Range Dim lngLoop As Integer Set xsht = ActiveWorkbook.Worksheets("Sheet1") lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row If lngLoop > 1 Then With CreateObject("Word.Application") .Vis

Re: $$Excel-Macros$$ Help Needed

Dear Sir I can able to create Notepad files , but i getting following error when trying to create word files Run Time Error User Defined is not found On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar wrote: > Hi, > > check this out > > Sub CreateWordDocs() > ' add a reference to the Word-library >

Re: $$Excel-Macros$$ Help Needed

Hi, Please find the attached text file. Copy and paste in that excel file and run. Regards Kumar On Tue, Mar 13, 2012 at 2:08 PM, Patil MG wrote: > Hi All > > can any one help me pl..its very urgent,,, > > > On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > >> Dear Exper

Re: $$Excel-Macros$$ Help Needed

Hi, check this out Sub CreateWordDocs() ' add a reference to the Word-library ' this is for creating number word Documents and renaming them with file names mentioned in 'C' column ' this code doesn't write any content, it just creates word documents and saves them Dim newapp As

Re: $$Excel-Macros$$ Help Needed

Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote: > Dear Experts, > > I have to create 'N' number of empty files of word and note pad files, > this word will long time to do can any one help to write a macro where in > which

Re: $$Excel-Macros$$ help needed??

"," & Cells(1, c) Next c Cells(r, "I") = Right(ms, Len(ms) - 1) Next r End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Sunday, February 26, 2012 10:23 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help needed??

Re: $$Excel-Macros$$ help needed??

thanks for help sir i am already done with if statement. chk attachment. and provide other solution vlookup/index-match On Sun, Feb 26, 2012 at 9:33 PM, xlstime wrote: > please find the attachment > > On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > >> Dear sir, >>plz dow

Re: $$Excel-Macros$$ help needed??

Instead of using the CONCATENATE function with multiple if conditions, better to use a simple helper column with a small formula like this J2=IF(C2="Y",IF(I2<>"",I2&",","")&C$1,TEXT(I2,"")) And H2=LOOKUP("ZZ",J2:N2) Regards, Sam Mathai Chacko On Sun, Feb 26, 2012 at 9:33 PM, xlstime w

Re: $$Excel-Macros$$ help needed??

My Try, =IF(AND(C2="Y",COUNTIF(D2:G2,"Y")),$C$1&",",IF((C2)="Y",$C$1,""))&IF(AND(D2="Y",COUNTIF(E2:G2,"Y")),$D$1&",",IF((D2)="Y",$D$1,""))&IF(AND(E2="Y",COUNTIF(F2:G2,"Y")),$E$1&",",IF((E2)="Y",$E$1,""))&IF(AND(F2="Y",COUNTIF(G2:G2,"Y")),$F$1&",",IF((F2)="Y",$F$1,""))&IF(G2="Y",$G$1,"") On Sun, F

Re: $$Excel-Macros$$ help needed??

please find the attachment On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > Dear sir, >plz download the attachment and help me... > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > He

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

Hi Sriram, Please find attached solved sheet. Thanks Mukesh - Original Message - From: sriram ji To: excel-macros@googlegroups.com Sent: Monday, October 24, 2011 7:04 PM Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and provide form

RE: $$Excel-Macros$$ Help needed..?

Rossoff Sent: Monday, October 24, 2011 8:16 AM To: 'Asa Rossoff'; excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help needed..? I agree with Sam that your requirement isn't 100% clear. He gave a solution for one interpretation. I'll flesh out mine. =IFE

RE: $$Excel-Macros$$ Help needed..?

24, 2011 7:54 AM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Help needed..? For book #s starting at 1001 and changing every 10 rows; Put in cell A2: =IFERROR(OFFSET(A2,-10,0)+1,1001) In case of Excel version prior to 2003, which doesn't support I

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

Maybe??? =IF(COUNTIF(A:A,D4)>=10,"No","") Don Guillett SalesAid Software dguille...@gmail.com From: sriram ji Sent: Monday, October 24, 2011 8:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed..? Dear All, Kindly find the attached file, and prov

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

So what exactly do you want? Your attachment isn't clear as to what formula you require. >From what I understood, have made a sheet with sequence of receipt leaflets, depending on the number of leaves and starting number. Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 7:04 PM, sriram j

RE: $$Excel-Macros$$ Help needed..?

For book #s starting at 1001 and changing every 10 rows; Put in cell A2: =IFERROR(OFFSET(A2,-10,0)+1,1001) In case of Excel version prior to 2003, which doesn't support IFERROR, use: =IF(ROW(A2)>11,OFFSET(A2,-10,0)+1,1001) Change default book # in formula as desired. Copy down.

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

el-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko > *Sent:* 02 October 2011 21:28 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help needed to find total & Unique count > from a range of moving dates > > ** ** > > Hi Amit, > &

RE: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

t; range. And yes, thanks a lot for appreciating Meru's service Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: 02 October 2011 21:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ H

Re: $$Excel-Macros$$ Help needed to find total & Unique count from a range of moving dates

Hi Amit, Follow steps carefully in sequence Add 3 named ranges as below Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT("z",20),LOG!$E$2:$E$1,1)) EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1)) Data=IF((EntryDate>=Sheet2!$A1)*(EntryDate<=Sheet2!$B1)=1,Vehicl

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

Here is one I like to use for setting variables (Options) in a file that is used by other Macros. Using the Macro below; I can toggle between True and False on the Options and Colors for specific cells. Available Options Star Font Size =16 Label Fo

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

Thanks rajan babu, for that link.Can anybody quote some more examples in detail.I just got a little understanding of the function with arguments.But to enhance my knowledge i would like to study more examples...Pls provide me with any other examples. On Sat, Oct 1, 2011 at 12:18 PM, rajan verm

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

Please VIsit this Page.. http://www.cpearson.com/excel/Events.aspx On Sat, Oct 1, 2011 at 12:09 PM, XLS S wrote: > Hey Rajan Babu, > > which page? > > > > > > On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > >> HI, >> Please visit this Page to know more about Worksheet Events.. >> >> Regar

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

Hey Rajan Babu, which page? On Sat, Oct 1, 2011 at 11:52 AM, rajan verma wrote: > HI, > Please visit this Page to know more about Worksheet Events.. > > Regards > Rajan > > On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > >> HI group, >> >> This is a Great & amazing group in learning exce

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

HI, Please visit this Page to know more about Worksheet Events.. Regards Rajan On Sat, Oct 1, 2011 at 10:53 AM, Mr excel wrote: > HI group, > > This is a Great & amazing group in learning excel vba.. > > > *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean)* >

RE: $$Excel-Macros$$ Help needed. compare two wxcel files

See if it helps , but Scop of this macro is only only Worksheet. Sub matchValue() ' Short CUt Key Shift + CTRL + M Application.ScreenUpdating = False Dim F_range As Range Dim S_range As Range On Error Resume Next Set F_range = Application.InputBox("Please Select 1st Range", , , , , , ,

Re: $$Excel-Macros$$ Help needed. compare two wxcel files

You need to post examples, etc. From: Rajendra prasad yadav Sent: Monday, August 08, 2011 1:31 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed. compare two wxcel files Hi friends, I am not good at excel. I have a requirement now, Can some one please give the macro t

RE: $$Excel-Macros$$ Help needed to comine VBA modules

31, 2011 at 1:57 PM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To: excel-macros@googlegroups.com It will be very difficult to move the code to the personal.xlsb workbook without the initial file retaining some code. Can you explain why you want to do so ? Maybe there should be a

RE: $$Excel-Macros$$ Help needed to comine VBA modules

> Target.ShowDetail = True > > ActiveSheet.Name = Target.Offset(, -1).Value > > End If > > End Sub -- Forwarded message -- From: Daniel Date: Sun, Jul 31, 2011 at 12:53 AM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To:

RE: $$Excel-Macros$$ Help needed to comine VBA modules

À : excel macro forum Objet : Re: $$Excel-Macros$$ Help needed to comine VBA modules Dear daniel, Thanks. Now it is working fine.But the sub 'Worksheet_BeforeDoubleClick' is included as worksheet level event routine of w.sheet analysis.How can i incorporat

Re: $$Excel-Macros$$ Help needed to comine VBA modules

> > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA mo

Re: $$Excel-Macros$$ Help needed to comine VBA modules

macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules > > Here is my test file. > > -Message d'origine- > De : excel-macros@goog

RE: $$Excel-Macros$$ Help needed to comine VBA modules

… each tim you double click on a value of the pivot, the worksheet will be created with the desired name. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 16:25 À : excel macro forum Objet : Fwd: $$Ex

RE: $$Excel-Macros$$ Help needed to comine VBA modules

Paste the macro below in the ANALYSIS module : Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim rg As Range Set rg = Sheets("ANALYSIS").PivotTables(1).DataBodyRange If Intersect(Target, rg) Is Nothing Then Exit Sub Cancel = True If T

RE: $$Excel-Macros$$ Help needed to comine VBA modules

HI, Can you explain a bit more ? Thanks. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 00:37 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Help needed to comine VBA

Re: $$Excel-Macros$$ Help needed to comine VBA modules

Thank u very much Daniel,can u help me in naming the sheets created while pivot table being drill down aju On Thu, Jul 28, 2011 at 2:46 PM, Daniel wrote: > Hi, > > You should indicate the file name before the function : > Eg. Personal.xlsb! SpellNumber... > > Regards. >

RE: $$Excel-Macros$$ Help needed to comine VBA modules

Hi, You should indicate the file name before the function : Eg. Personal.xlsb! SpellNumber... Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : jeudi 28 juillet 2011 06:10 À : excel-macros@googl

  1   2   >