$$Excel-Macros$$ Help Required

Hi All, I need your help to make an automation of the attached worksheet. In the attached workbook different columns have been given . We have to searched for duplicate entries in column Service Provider, From and To. If values entered in these 3 columns are same then it should be displayed “Yes”

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

Andy, Thanks for the link. I've book marked it to try out some of the stuff in there. Regards, Steve On Aug 12, 9:52 pm, Aindril De wrote: > Hi Steve, > > In Excel 2007 certain things have changed in the VBA front as well. While > saving the file in any XML format that is .xlsx in this case,

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

Thanks Paul. I read through what you had and changed the file format to: FileFormat:=xlOpenXMLWorkbook And that solved my problem. Regards, Steve On Aug 13, 9:14 am, Paul Schreiner wrote: > There's a couple of key statements you've made: > > "I went to update it to work for Excel 2007" > >

Re: $$Excel-Macros$$ if iteration

Angelo, I didn't use iteration. Perhaps you're confusing the concept of iteration with something else. Iteration is a special kind of resource in writing formulas for excel, that takes advantage of circular references. Google for "excel iteration" for more on this, or see for example here: http://p

RE: $$Excel-Macros$$ Need to remove Alt + Enter

Hi Nadine, Did you format the cell with Wrap text? Dave. Date: Fri, 13 Aug 2010 08:46:15 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter To: excel-macros@googlegroups.com Thanks Dave. This still shows the info as all one line/sentence. I st

$$Excel-Macros$$ Macro help - resize a column that is part of pivot table

Hi everybody - I am hoping someone can help me out with a problem that I am having. I am trying to edit a macro, but I do not have a lot of experience writing macros and I cannot figure out the issue. I have a spreadsheet with a macro that does some formatting and refreshes a pivot table in a diff

Re: $$Excel-Macros$$ if iteration

Hi, thanks, yes, is the number of if iteration ilimited? Regards 2010/8/12 Bruno Bruno > See if it's this what you want. > > > On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola > wrote: > >> Dear Bruno, >> >> I will send you an attachment, so i can make this clear. Result is based >> on size a

Re: $$Excel-Macros$$ Need to remove Alt + Enter

Thanks Dave.  This still shows the info as all one line/sentence.  I still need the info to show as 3 lines/sentences in one cell.  :( Nadine From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Fri, August 13, 2010 6:30:32 AM Subject: RE: $$Excel-M

Re: $$Excel-Macros$$ Conditional Formatting on a formula

Thanks but this still isn't working if the formula result for a cell is blank. From: Rajender Soni To: excel-macros@googlegroups.com Sent: Thu, August 12, 2010 8:51:03 PM Subject: $$Excel-Macros$$ Conditional Formatting on a formula Hi Please find attached t

Re: $$Excel-Macros$$ help required

> Hi Paul > > wonderfull, its workingya we are using this frequently and destinations > also more than thousand some times. > > thanks friend, i want some more help from u for same file. > > this macro u provided me text column using , > > but some times i ll get , ; both > > and number's like

Re: $$Excel-Macros$$ Excel macro delete columns - starting row 23

Attached sample data... Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/gro

$$Excel-Macros$$ Risk

Dear Team, Does anyone have excel spreadsheets for dtermining capital,operational and market risk Sri -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.c

RE: $$Excel-Macros$$ Need to remove Alt + Enter

Hi Nadine, If your original text is in A3, try this formula in another cell: =SUBSTITUTE(TRIM(SUBSTITUTE(A3,CHAR(10)," "))," ",CHAR(10)) You will need to format the formula cell with 'Wrap Text' Alt+Enter is a CHAR(10) character. The formula substitutes all these for spaces, then applies the T

Re: $$Excel-Macros$$ help required

Hi Paul wonderfull, its working thanks friend, i want some more help from u for same file. this macro u provided me text column using , but some times i ll get , ; both and number's like 9321-9325 this should be 9321 9322 9323 9324 can add these on same macro and send me back thanks in

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

There's a couple of key statements you've made: "I went to update it to work for Excel 2007" and: "until I changed ".xls" to ".xlsx"" First of all, is the macro IN the file you're saving? or is this macro opening another file, modifying and saving it? because, first of all, Excel2007 doesn't "us

Re: $$Excel-Macros$$ help required

Is this something you have to do frequently? I was able to do it manually in 5 minutes by using Text-to-Columns then copy/paste special, transform to get it into column form, then copied the carrier name down each column and move it into the first pair of columns. But if you do it frequently, it c

$$Excel-Macros$$ How to open WK1 formated file with Excel 2007

Hello, I am not able to open lotus formatted files (with extension WK1) using Excel 2007. However, I am able to open it with Excel 2003. Please help. I have uploaded a file just now for you guys to check. thank you cheers Harris -- -