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. 

$$Excel-Macros$$ Help Needed on Index

Dear All, Attached file has a small exercise done on INDEX function , Presently cells C21 to C29 has numbers, Instead of that how can I replace those cells with the names of the cities given in the table and continue using INDEX function ? Do I need to do this with a macro ? Note this is part of

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

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

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

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

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. . For example I receive mail1, mail2, mail3, mail4 then I want all 4 mails to be attaches in on mail (Mail All) as an attachment

$$Excel-Macros$$ Help needed on average formula

Dear Mandeep, Please Help. Regards, Kumar Bhanushali DISCLAIMER The information contained in this e-mail including attachment is meant only for the addressee and may contain confidential and privileged information. Any use, distribution, printing, retransmission, dissemination, copying or

$$Excel-Macros$$ Help needed

Hi, Just want to solve the questions with analysis. please find the enclosed attachment and answer the question. I also trying to solve. But needed Gurus help. Thanks -- 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

$$Excel-Macros$$ Help Needed

Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards,

$$Excel-Macros$$ Help Needed

Dear Guru's If Forecast Deviation Answered on forecast is = 110% it must shown as 80% or else Answered with TH / Net call Offered. Please Help me. [image: Inline image 1] Thanks Reargds, Sriram -- 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)

Re: $$Excel-Macros$$ Help Needed

- From: sriram ji sriramg...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, November 25, 2014 6:22 AM Subject: $$Excel-Macros$$ Help Needed Dear Guru's If Forecast Deviation Answered on forecast is = 110% it must shown as 80% or else

Re: $$Excel-Macros$$ Help Needed

:* Tuesday, November 25, 2014 6:22 AM *Subject:* $$Excel-Macros$$ Help Needed Dear Guru's If Forecast Deviation Answered on forecast is = 110% it must shown as 80% or else Answered with TH / Net call Offered. Please Help me. [image: Inline image 1] Thanks Reargds, Sriram -- Are you =EXP

$$Excel-Macros$$ Help needed enclosed template also

Dear all, i need your help in attached excel. In Worksheet named 'Master' - Daily prices are hand filled from various weblinks and sources. In 2nd worksheet named 'pivot'- i get table from master sheet for variety prices in different markets. Here the blanks remain blank In 3 rd worksheet

$$Excel-Macros$$ Help needed

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

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? And do you

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

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 Mumbai - we will have first Bar will be for 5, 2nd sub bar should be within the first bar of 5500 3rd sub bar should be

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) amit.de...@merucabs.com 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...

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,

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

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

-to-make-a-better-excel-sales-pipeline-or-sales-funnel-chart/ Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Kumar Sent: Wednesday, September 24, 2014 7:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help

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

Hi, Check this!! Final shot from my side. 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

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

@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart Hi, Check this!! Final shot from my side. 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

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

@googlegroups.com] *On Behalf Of *Ashish Kumar *Sent:* Wednesday, September 24, 2014 8:11 PM *To:* excel-macros@googlegroups.com *Subject:* Re: FW: $$Excel-Macros$$ Help needed for 2 Layered Bar Chart Hi, Check this!! Final shot from my side. Regards Ashish -- Are you =EXP(E:RT

$$Excel-Macros$$ Help Needed

Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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 @

Re: $$Excel-Macros$$ Help Needed

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

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 todhavals...@gmail.com wrote: fyi Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com todhavals...@gmail.com* On Tue, Jun 17, 2014 at 12:51 PM, Rakesh

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 py.har...@gmail.com wrote: Dear Excel Gurus, Please find the attached file Marks Sheet, and i want to obtain the marks

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

Re: $$Excel-Macros$$ Help Needed

Dear, use this. =num2text(reference) Please check attachment. thanking you On 4 February 2014 09:42, Harish P Y py.har...@gmail.com 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.

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 py.har...@gmail.com wrote: Dear Excel

Re: $$Excel-Macros$$ Help Needed

This is very useful. http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.htmlhttp://support.microsoft.com/kb/213360 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

$$Excel-Macros$$ Help Needed

Dear Excel Gurus, Please find the attached file Marks Sheet, and i want to obtain the marks obtained in words and the result obtained as indicated in the attachment. Kindly help me out in sorting out this. Regards Harish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

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 do you

$$Excel-Macros$$ Help needed

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

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/

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

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

Hi, I am working in HR department in a manufacturing company and want to create a dashboard. Please guide me in preparing the same like the things to be covered in the dashboard How can I link some list box or combo box to a chart in the dashboard without macro i.e. through formulas if it can

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

$$Excel-Macros$$ Help Needed

Hi Every One can anyone help how to converted Number in words into Numeric Values let me know is their any formula or macro for for this Kindly refer the attached sample date -- Thank You Patil MG 91 99016 16995 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

: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, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote: pls provide excel or explain more about your query

$$Excel-Macros$$ help needed urgent

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 =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 @

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 thamee...@gmail.com 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... --

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

thanks.. its done On Wed, Aug 21, 2013 at 4:05 PM, vba v...@vabs.in 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 thamee...@gmail.com wrote: Dear all, file is in server, but no one is

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

: *Cc:* ravinder negi ravi_c...@yahoo.com javascript: *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, August 7, 2013 2:34:57 PM UTC+5

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

...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *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 of a horizontal row one below the other as: A B please tell me

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

pls provide excel or explain more about your query... From: Pankaj pankajdhamij...@gmail.com 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

$$Excel-Macros$$ Help needed in Excel

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 the contents manually using Alt + Enter. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

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 AM,

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 =

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

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,

Re: $$Excel-Macros$$ Help needed

thank you it working On Sun, Jul 14, 2013 at 3:58 PM, ashish koul koul.ash...@gmail.com 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 =

$$Excel-Macros$$ Help needed

Dear Experts, I need help, using excel, I need open files from a folder. Example, I have 5000 files is a folder, I have file names in excel, i need to open any one file using excel. its like that seraching that file name in that folder, if available, then that file should be opened. I have you

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 =

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 d...@premor.net wrote: Hi Patil, PFA Please Run Procedure named *GenerateFromTemplate * Rgds, [dp]* * Pada 10/07/2013 18:30,

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 vijay.4...@gmail.com wrote: Respected Thameem, After inserting the graph you get

$$Excel-Macros$$ help needed

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, Thameem.m -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ help needed

Can you please share your file On Sun, Jun 9, 2013 at 2:32 PM, thameem thamee...@gmail.com 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

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 pritiverma1...@gmail.comwrote: Can you please share your file On Sun, Jun 9, 2013 at 2:32 PM,

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

Re: $$Excel-Macros$$ Help Needed

*- -- *From:* Patil MG mailpati...@gmail.com *To:* excel-macros@googlegroups.com; Patil M G Gmail mailpati...@gmail.com *Sent:* Wed, June 5, 2013 9:25:36 AM *Subject:* $$Excel-Macros$$ Help Needed HI Team Excel Experts I am learning Excel and new to Macro coding. I want to create attached

$$Excel-Macros$$ Help Needed

Hi experts, i need the below simple thing. assume, you have five sheets in workbook. considere sheet 1 is home sheet. i want to list the rest sheets in sheet 1 column A1. like : if i click A1 in sheet 1, it should list the the other sheets from Sheet 2 to Sheet 5. also if i add more sheets that

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

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 abhishek@gmail.com 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

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 prabhupin...@gmail.comwrote: thanks abhi, but i need this to be listed in drop down menu. regards prabhu r On 15

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 abhishek@gmail.com wrote: You did not mention that in

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 prabhupin...@gmail.comwrote: Hi abhi, thanks for your quick help. it really works fine. i need one more

Re: $$Excel-Macros$$ Help Needed

oh yeah its working.. thanks abhi... :D regards Prabhu R On 15 May 2013 10:49, Abhishek Jain abhishek@gmail.com 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

$$Excel-Macros$$ Help needed

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 500012 XYZ500134XYZ 500134 Regards, Kaushik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Help needed

=MID(A1,FIND(5,A1),6) On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Help needed

Thank You very much for prompt response! On Thu, Apr 11, 2013 at 10:22 PM, ashish koul koul.ash...@gmail.com wrote: =MID(A1,FIND(5,A1),6) On Thu, Apr 11, 2013 at 10:16 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, I need a formula to find anything starting from 5 in a cell

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

Sent: Thu, October 25, 2012 4:56:46 PM Subject: $$Excel-Macros$$ Help needed to write For/End loop using Range statement ... Hi, I would like your help in writing a simple macro that will perform a For/End loop around a .Range statement. I would like the cells in the Range statement

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

Hi, I would like your help in writing a simple macro that will perform a For/End loop around a .Range statement. I would like the cells in the Range statement to increment by 1 for X number of times. My problem is I do not know how to change the code so that the cells are incremented by the do

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

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 kie...@freenet.de 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.

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.

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

Hi NG, I need to insert a function into cell D1 with an Excel2007 macro that executes the following: A B C D row 1 12343 row 21 123444 row 31 43322 row 4

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),c123400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM, Henning Deschka kie...@freenet.de 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 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 palande.swapni...@gmail.com wrote: Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c123400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM,

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

Thank you its working On Mon, Sep 3, 2012 at 5:22 PM, Amresh Maurya amreshkushw...@gmail.comwrote: 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

$$Excel-Macros$$ Help needed in sum

Dear all, -- Regards Rambabu. G -- 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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

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 rambabu1...@gmail.comwrote: Dear all, -- Regards Rambabu. G -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

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 noorain.ans...@gmail.comwrote: Please try =SUMIFS($I$15:$I$24,$J$15:$J$24,N15,$K$15:$K$24,=O15) On Mon, Sep

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 noorain.ans...@gmail.comwrote: 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

$$Excel-Macros$$ Help needed

Hello Team, Could you please help me in the below scenario. I have two different reports from which I have to prepare a single report for reporting purpose. In sheet 1 the reports contains tracking#, HW details etc. and sheet 2 the report contains the values of the HW, tracking # etc The

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

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

Hi Group, Need another help to count and sum data between two fixed dates. Regards Santosh santoshkumar.subu...@gmail.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

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

$$Excel-Macros$$ Help needed !!!

Dear Exports, Please find attached a file help for formula. Regards, Iqbal Shaikh -- -- FORUM RULES (986+ 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

$$Excel-Macros$$ help needed - VBA

Hi All,   I'm new to macros so I'd like to ask you for advice. Can you look at code below and help me to improve. What I'd like to do is make changes to BOLDED line (Windows(LowRisk EPlan SAUCE week 19.xls).Activate) in order to activeted open file (in this case file is called LowRisk EPlan

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

) End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pawel lupinski Sent: 09 May 2012 5:45 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help needed - VBA Hi All, I'm new

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

Hi All, I have one JPG/Png/Gif format file, is there any way where i can convert this JPG format file to Excel file to make some changes? your reply will be greatly appriciated. -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before

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

-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA Hi All, I have one JPG/Png/Gif format file, is there any way where i can convert this JPG format file to Excel file to make some changes? your reply will be greatly appriciated

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

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-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Help needed- Converting JPG format file to Excel file via VBA

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 chimir...@gmail.com wrote: Hi, check this out Sub CreateWordDocs() ' add a reference to the

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) .Visible

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 mailpati...@gmail.com 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

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 mailpati...@gmail.com wrote: Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG

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

$$Excel-Macros$$ Help Needed

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 i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the

  1   2   >