$$Excel-Macros$$ Hi - Number need to fill randomly

Hi Team, I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly by clicking the button "Press" each time. Finally we need the data as highlighted in yellow. Thanks Manjunath -- -- Some important

Re: $$Excel-Macros$$ if formula help

Solved & file Attached. Hope it serves the purpose. Regards, C.G.Kumar On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > Dear All, > > please help me with the formula where in I should get the result > > 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then > B2-30

Re: $$Excel-Macros$$ if formula help

Hi Abhinda, PFA the solution.. Regards, Andy On Wed, Dec 8, 2010 at 10:10 AM, Abhidha Dixit wrote: > Dear All, > > please help me with the formula where in I should get the result > > 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then > B2-300, subsequelntly I hve tried

Re: $$Excel-Macros$$ Reqd : Add in to convert Numbet to text in Excel 2007

Yes its workingThanks On Tue, Dec 7, 2010 at 5:32 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > > hello Radhe, > > Please find the attached addin.. > > Hope this helps you.. > > Regards, > Raj > > > On Tue, Dec 7, 2010 at 2:43 PM, Radhe Sham wrote: > >> H

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

Hi, I am unable to download the OPEN XL, can any one help the procedure On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Probably the communication from my side was not clear > > The help i

$$Excel-Macros$$ if formula help

Dear All, please help me with the formula where in I should get the result 1 IF left 3 strings is ABH then B2 -200, IF DIX then B2 -400 , IF DEL then B2-300, subsequelntly I hve tried but somehow i am not getting the desired result Regards Abhidha -- --

$$Excel-Macros$$ Read Only Password and Modify Password

Hello, I am exporting queries from Access to an excel file. I want to have the ability for a read only password and a modify password. Currently I am just able to export the file with a password to open the file. Please let me know if any more information is needed. Thank you, John --

RE: $$Excel-Macros$$ Error in Macro Code

Hi Vebhav, You say you need to change the highlighted code daily, but you don't say what you change it to, or on what basis it is changed. We need to know this if we have any chance of helping you automate the process. Regards - Dave. Date: Wed, 8 Dec 2010 06:51:01 +0530 Subject: Re: $$E

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

You can use substitute in front of the UDF to replace the word to your desired local currency right. Another Method:- Follow the below link and download the MoreFuction Addin from that and run the setup. http://download.cnet.com/Morefunc/3000-2077_4-10423159.html After doing that open excel and

Re: $$Excel-Macros$$ Error in Macro Code

Can someone look into this and suggest me. On Tue, Dec 7, 2010 at 10:33 PM, vebhav jain wrote: > Hello, > > Can you please help me in making this code in a standard format, instead of > changing the code daily manually of the highlighted text. Thanks in Advance. > > Sub macro1() > ' > ' Macro1 M

RE: $$Excel-Macros$$ Error in Macro Code

Hi Vebhav, You say you need to change the highlighted code daily, but you don't say what you change it to, or on what basis it is changed. We need to know this if we have any chance of helping you automate the process. Regards - Dave. Date: Tue, 7 Dec 2010 22:33:00 +0530 Subject: $$Excel-Mac

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Numbet to text in Excel 2007

http://code.google.com/p/openexcel/downloads/list Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Tue, Dec 7, 2010 at 9:27 PM, OpenExcel.com wrote: > Hi Radhe, > > It seems you don't know about 'O

$$Excel-Macros$$ Error in Macro Code

Hello, Can you please help me in making this code in a standard format, instead of changing the code daily manually of the highlighted text. Thanks in Advance. Sub macro1() ' ' Macro1 Macro ' ' Dim Z As Long Range("H2").Select ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-6],RC[-5],RC[-1])"

Re: $$Excel-Macros$$ Check if two files are open; if not, open them

in an if-else-then statement, if the first is false, then Else is evaluated. So, if File1 not open, it opens it. In that case, Else is not evaluated! simply use two separate if-then statements:  If Not WorkbookOpen("File1.xls") Then     Workbooks.Open Filename:="C:\File1.xls"  End If  If Not

$$Excel-Macros$$ Check if two files are open; if not, open them

With File3.xls open, I'd like to run a macro that checks if File1.xls and File2.xls are open. If either or both are not open, then open them. The code below evaluates only the first file (File1.xls), and never proceeds to the next step (i.e., it never checks for File2.xls). Any idea what I need to

Re: $$Excel-Macros$$ Select the next cell when the page open

Hi i got a mistake in my code here is the correct one Private Sub Worksheet_Activate() Dim lastrow lastrow = Cells(Rows.Count, 12).End(xlUp).Offset(1, 0).Row Cells(lastrow, 12).Select End Sub Regards Rajesh kainikkara On 12/7/10, Rajesh K R wrote: > HI Daniel > here is the code what i am using t

Re: $$Excel-Macros$$ Select the next cell when the page open

HI Daniel here is the code what i am using the last raw in a work sheet when it activate i want a code like this instead of row here i want to find the next column. Private Sub Worksheet_Activate() Dim lastcolumn lastcolumn = Cells(Columns.Count, 12).End(xlUp).Offset(1, 0).Row Cells(lastcolumn, 12

$$Excel-Macros$$ Check if two files are open; if not, open them

With File3.xls open, I'd like to run a macro that checks if File1.xls and File2.xls are open. If either or both are not open, then open them. The code below evaluates only the first file (File1.xls), and never proceeds to the next step (i.e., it never checks for File2.xls). Any idea what I need to

Re: $$Excel-Macros$$ error in macro

Hi Daniel Now its working well, i finished the project . Regards & Thanks Rajesh Kainikkara On 12/6/10, Daniel wrote: > Sorry, I did not test that part of the code - nor did you ;-)) > > Sub Go2sheet() > myShts = ActiveWorkbook.Sheets.Count > For i = 1 To myShts > myList = myList & i & " - " &

Re: $$Excel-Macros$$ Copy an absolute column and relative row to the right

Thank you everyone. This did the trick: In B1 =INDIRECT("A"&COLUMN(A1)) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Li

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

HI Ashish , Sorry to trouble you again Spell Numbers convers the number into words in the same location while what is requires is the numbers are to be translated into words in a different location. I have attached a file with the format in which the numbers are requires to be mentioned in words

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

Are you saying that you have an EXISTING Excel file, when you double-click, it doesn't open, but if you right-click, there is a menu that allows you to open the file? > >From: Born to Win >To: excel-macros@googlegroups.com >Sent: Tue, December 7, 2010 3:05:56 AM >Subject: $$Excel-Macros$$ need u

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

Try this link out... http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html Regards, Manoj Vishwakarma On Tue, Dec 7, 2010 at 5:52 PM, Radhe Sham wrote: > Hi Ashish, > > Many thanks for the kind help in providing valuable information about > Openexcel. > > Proba

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

Hi Radhe, 1. Download Open Excel from http://www.openexcel.com 2. Install it 3. Open your Workbook. 4. Go to 'Open XL' tab. 5. Go to 'Number Utils' 6. Click on 'Spell Numbers' and you're done. It does exactly what you mentioned and have around 100 more useful utilities, you probably would be usin

$$Excel-Macros$$ Re: cumulative sum in pivot table

Hi Alisha, Use the 'Running Total in' option in 'Value Field' settings (Go to 'Show Value as' tab) to generate the cumulative sum in pivot table. Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional)

$$Excel-Macros$$ cumulative sum in pivot table

Hi Group, I have one pivot table. In that I want to show the cumulative sum. e.g. Qtr1 sale:- 10 units Qtr2 sale:- 20 units Qtr3 sale:- 10 units Qtr4 sale:- 30 units now i want to show the sale of qtr1 and qtr2 i.e. 30 units after qtr2 and similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e.

Re: $$Excel-Macros$$ Re: Reqd : Add in to convert Number to text in Excel 2007

Hi Ashish, Many thanks for the kind help in providing valuable information about Openexcel. Probably the communication from my side was not clear The help i was seeking was to convert the value to be mentioned in words For example if a cell has 523.25; this value should be displayed in words as

$$Excel-Macros$$ Re: Reqd : Add in to convert Numbet to text in Excel 2007

Hi Radhe, It seems you don't know about 'Open Excel'. Download and you can do many things other than this. Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.ope

Re: $$Excel-Macros$$ Copy an absolute column and relative row to the right

Hi! If you have more than one column of data in source file I think it can be useful to use R1C1 reference style: =INDIRECT("R"&COLUMN()&"C"&ROW(),0) Regards, J. On 6 Gru, 17:53, roberto mensa wrote: > In B1 > =INDIRECT("A"&COLUMN(A1)) > > regards > r > > 2010/12/6 0 1 > > > > > > > > > The so

$$Excel-Macros$$ Reqd : Add in to convert Numbet to text in Excel 2007

Hi Group , The addin for converting a number to text which was working in Excel 2003 does not seem to work in Excel 2007 Can anyone kindly help with an add in for Excel 2007 for converting number to text please Thanks and regards Radhe -- --

$$Excel-Macros$$ need urgent help

Hi Expert, i have a challenge when i am going to open a new excel file i am not able to open that file directly however after right click then its working.please let me know what i should do to change that configuration. Thanks, Chandrabhan Singh -- -