Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, You can also use simple... First Select Range Goto Data>Text to Column>Delemated>Remove Space>Enter Then you can use SUM Function - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.c

$$Excel-Macros$$ Re: saving command button not functioning

Please add the following code. rst.update after assigning values to the fields Also instead of using rst.fields(0), --- you can use rst.fields("fileno") which will be more legible and readable. Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("select * from t_

Re: $$Excel-Macros$$ Formula Help

Thanks to all for the Prompt reply. The problem is solved. Regards Hemant Dange On Dec 7, 9:55 pm, "dguillett1" wrote: > A macro to populate column B > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > -Original Message- > From: hemant > Sent: Wednesday, December 07, 201

$$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture

Hi Macro team, I have a lot of tables in excel that I need to paste on powerpoint. Please help me. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Great Macro Don! Very helpful for my task... I really appreciate your assistance with this and you were also very fast at responding. You are awesome :-) Sunnie On Wed, Dec 7, 2011 at 4:51 PM, dguillett1 wrote: > Not really. It was using the first Sunday of the current year and adding a > 7

$$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell

Hello All, Firstly, Thanks for all the contribution to this wonderful community. Has been a lot of help always. Coming to my Query...I need to get the data in certain cells (text and numeric) to display single quotes at the start and the end. Have tried this saving the excel sheet in all formats

Re: $$Excel-Macros$$ About Marcros in 2007

Thanks for the PPT. I'll read it & try to develop VBA. Codes :) -- 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 attentio

$$Excel-Macros$$ Get email from Mail Client

I'm using MS Outlook 2007 and I'm making a call to my mail folder to get the mail items. I need to get the email address, but it is providing me with an email address like: /O=mycompany/OU=SITE07/CN=RECIPIENTS/CN=hillgoogle My code looks like: Dim olApp As Object Dim i As Integer S

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Not really. It was using the first Sunday of the current year and adding a 7 days so you would have 52 sheets. I have changed it to use Jan 1, 2012 as the starting date, adding a week for each sheet. See attached, Don Guillett SalesAid Software dguille...@gmail.com -Original Message- F

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Attach your final result for comments Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Susan 1 Sent: Wednesday, December 07, 2011 5:56 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workboo

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

I believe then I'll need to make a template sheet :-)... okay thanks for clarifying it! :-) Appreciated!! On 12/7/11, dguillett1 wrote: > The macro assumes that you do, indeed, have a sheet named Template that you > want to copy and name jan 03, jan 10, etc. > > Don Guillett > SalesAid Software

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

Not figured out what your macro ishowever what I can suggest you can use the Offset function to have the range of the Conditional formating extended automatically. Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply conditional formatting in the column A. Put the above stated formula

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

The macro assumes that you do, indeed, have a sheet named Template that you want to copy and name jan 03, jan 10, etc. Don Guillett SalesAid Software dguille...@gmail.com From: Susan 1 Sent: Wednesday, December 07, 2011 2:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fo

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

I copied and pasted your code from below in a blank spreadsheet and when I run it I received the following error: Script out of range. Please advise. Thanks![?] On Wed, Dec 7, 2011 at 7:04 AM, dguillett1 wrote: > This macro will copy the template and name each sheet with the start of > the w

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Hi Noorain, The macro only worked for the first sheet, after I run it again I receive this error #: 1004 Sheets(Sheets.Count).Name = Sheet18.Cells(i, "A").Value On Tue, Dec 6, 2011 at 8:09 PM, NOORAIN ANSARI wrote: > Dear Susan, > > Please try it and see attached sheet. >

Re: $$Excel-Macros$$ कविता : जलवा COUNTIF का (20 Tips to use Countif Function)

Great Haseeb, Thanks for your valuable Suggestion... Really you are magician of Excel Formula -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Also, select col_E press Ctrl+H to activate Find/Replace, from the keyboard NUMERIC side (right side of the keyboard, not the top row) Press Alt+0160 in Find What box: and click Replace All. Now you can do a simple SUM. Or use this Array Formula, =SUM(IFERROR(--SUBSTITUTE(E2:E18,CHAR(160),""),

Re: $$Excel-Macros$$ Extract Number In String - EXCEL Formula

You can use this as well... =MID(C9,1,FIND("_",C9)-1) Thanks Rohan. -- 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

Re: $$Excel-Macros$$ Formula Help

A macro to populate column B Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: hemant Sent: Wednesday, December 07, 2011 2:30 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Formula Help Hi all I need help on the following in EXCEL 2007: Compare

Re: $$Excel-Macros$$ How can click on HTML button using it's class.

Try this For each Element in HDoc.getelementbyclass("abc") element.click next element On Wed, Dec 7, 2011 at 2:34 PM, Mithlesh Sharma wrote: > Hi Friend, > > Can we click on HTML button using > getelementbyclass("abc").click, if this is possible please let me know with > example. > > >

Re: $$Excel-Macros$$ Progress bar - urgent

see the attached File.. On Wed, Dec 7, 2011 at 12:34 PM, NOORAIN ANSARI wrote: > Dear Dharti Kumar, > > Please see attached doc to create Progress bar in Excel. > > - > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://no

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

This macro will copy the template and name each sheet with the start of the week (short names better) If you want the first MONDAY then change ,7 to ,8 Option Explicit Sub addsheets() Dim i As Long For i = Day(DateSerial(Year(Date), 1, 7) - _ WeekDay(DateSerial(Year(Date), 1, 6))) To 365 Step 7 Sh

Re: $$Excel-Macros$$ Formula Help

hi please see the attached File.. Hope this will help Rajan. On Wed, Dec 7, 2011 at 2:00 PM, hemant wrote: > Hi all > > I need help on the following in EXCEL 2007: > > Compare the values of sheet 1:column A with Values of Sheet2:column A > > If the CELL values in sheet1 column matches with Rang

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

hi please use this Array Function with Shift+Ctrl+Enter ={SUM(VALUE(LEFT(E2:E18,LEN(E2:E18)-1)))} On Wed, Dec 7, 2011 at 2:45 PM, Maries wrote: > > Hi Lakshman, > > Please use the below codes: > > Sub Right_Delete() > ' This module will delete text from Right in selected cells. > Dim MyCell

Re: $$Excel-Macros$$ Extract Number In String - EXCEL Formula

Hi Please use this : =TRIM(LEFT(A1,FIND("_",A1,1)-1)) On Wed, Dec 7, 2011 at 4:00 PM, Raghunandan wrote: > Hi All, > > Can someone help me out to extract number from string in Excel. > > Ex: 1_EB_AHR should write 1 > 456_EBF_RTY should write 456 > 1456_HGH_FG should write 1456 > > Tha

Re: $$Excel-Macros$$ Extract Number In String - EXCEL Formula

=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$1 On Wed, Dec 7, 2011 at 2:30 PM, Raghunandan wrote: > Hi All, > > Can someone help me out to extract number from string in Excel. > > Ex: 1_EB_AHR should write 1 > 456_EBF_RTY should write 456 >

$$Excel-Macros$$ Extract Number In String - EXCEL Formula

Hi All, Can someone help me out to extract number from string in Excel. Ex: 1_EB_AHR should write 1 456_EBF_RTY should write 456 1456_HGH_FG should write 1456 Thanks... -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Thanks to all with the help of all of U, I understand the main problem. From: Maries To: excel-macros@googlegroups.com Sent: Wednesday, 7 December 2011 2:45 PM Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum Hi Lakshman, Please use

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

thanks to all From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, 7 December 2011 3:08 PM Subject: Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum Dear Lakshman, Please try it and see attached Sheet.. Sub Remove_Space()

Re: $$Excel-Macros$$ MS Access solution

Hello Rohan, Even though Excel and Access are two products of MS-office, working with them is quite different. While in excel the core term is cell, which when culminated leads to rows, columns, worksheets & workbooks. In excel we work with formulas & functions, with relative or absolute cell add

$$Excel-Macros$$ Re: Ledger opening balance and balance in MS Access

You can create a form or report, with the required format. It is needed to write VBA code based upon the dates given. As u said If you require report from 01-jun-2010 to 31-aug-2010, which will be provided as inputs to form/report Then it is required to calculate the opening balance which is obvio

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, Please try it and see attached Sheet.. Sub Remove_Space() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) > 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(C) End If Next Application.Scree

$$Excel-Macros$$ How can click on HTML button using it's class.

Hi Friend, Can we click on HTML button using getelementbyclass("abc").click, if this is possible please let me know with example. Thanks Mithlesh Sharma -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Hi Lakshman, Please use the below codes: Sub Right_Delete() ' This module will delete text from Right in selected cells. Dim MyCell As Range Dim Total_Chars As Integer On Error Resume Next Total_Chars = 2 For Each MyCell In Selection.Cells If Len(My

Re: $$Excel-Macros$$ Formula Help

Dear Hemant, You can use below function with Conditonal Formating.. =MATCH($A1,Sheet2_range,0) Sheet2_range is name range of Sheet2 B Column. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Sorry NOT USING TRIM On Wed, Dec 7, 2011 at 2:39 PM, Aindril De wrote: > NOTE: > I am using the simple TRIM(<>) function as the data you have sent contains > multiple spaces in the trail. > > > On Wed, Dec 7, 2011 at 2:35 PM, Aindril De wrote: > >> Dear Lakshman, >> >> You are not able to do th

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

NOTE: I am using the simple TRIM(<>) function as the data you have sent contains multiple spaces in the trail. On Wed, Dec 7, 2011 at 2:35 PM, Aindril De wrote: > Dear Lakshman, > > You are not able to do the SUM as the data in the last column has leading > and trailing spaces. > You can use the

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Lakshman, You are not able to do the SUM as the data in the last column has leading and trailing spaces. You can use the add-on http://www.ablebits.com/excel-trim-spaces/index.php to quickly remove the spaces, if you regularly receive/generate such data. Cheers, Andy On Wed, Dec 7, 2011 at

Re: $$Excel-Macros$$ Formula Help

Dear Hemant, It can be achieved using the vlookup formula. Suppose you have a data set in Sheet 1 from A1 to A9, which you need to compare with the values present in column A in Sheet 2 Then in Column B, please type: =VLOOKUP(A1,Sheet1!$A$1:$A$9,1,0) and drag the formula down. You will get some

$$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear All, Plz see the attach file. I can’t understand why I m unable to do sum. What is the problem in sheet or number? Help anybody? Regards LAKSHMAN -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgen

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

Hi Rajan, Thanks for your prompt response. After testing this code. I had the following output: Files created with .xml extension, according to the number of records. These files were in the XML format, however the Tags were not as per the column heads. following is a sample output: - http:

$$Excel-Macros$$ Formula Help

Hi all I need help on the following in EXCEL 2007: Compare the values of sheet 1:column A with Values of Sheet2:column A If the CELL values in sheet1 column matches with Range of values in Sheet2 column. copy that CELL VALUE from sheet1 and paste it adjacent column (Column B) of sheet2. Or COLO