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

Hi Please find attached the solution sheet. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldaily

$$Excel-Macros$$ Re: Excel VBA : Unique Values

Hi, You may have to mess with this a little to get the names to write where you want, but it works. It writes to Column N at this point. Hope it helps. Thanks, David Sub UniqueValues() 'Created 1/13/2010 by David Lanman 'loop to find unique values only, random values start in A1 Range("E4"

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

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, you need to supply the file fomat value as well. The following link will give you further details on this. http://www.rondebruin.nl/saveas.htm Regards,

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

Hi, I have this macro that someone had helped me with quite a while ago. It was working fine until I went to update it to work for Excel 2007. The macro below is what it was until I changed ".xls" to ".xlsx". 'SaveAsExcelWorkbook2() 'Remember to add the reference to Microsoft Scripting Runtime D

Re: $$Excel-Macros$$ if iteration

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 and code as you can see... i have put some sample data for column that > i desire that is result. > > Regard

Re: $$Excel-Macros$$ if iteration

Dear Bruno, I will send you an attachment, so i can make this clear. Result is based on size and code as you can see... i have put some sample data for column that i desire that is result. Regards, Angelo Spinola 2010/8/12 Bruno Bruno > Hi Angelo, > I'm still confused about exactly what you wa

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

thanks... Here is the details: Geniri ID Year Cutoff Lot info I23 I23 199123 I24 I24 199944 I25 I25 200133 I26 I26 200411 I27 I27 2006

$$Excel-Macros$$ Re: count if with multiple conditions

This is a simple exercise with pivot table. On Aug 12, 3:42 am, HARI NAIR wrote: > In the attached file I want to know  three results, how many persons given 4 > marks, out of which how many females , how many males.Please help me. Thanks > in advance. > > Regards, > > Hari > >  Book1.xls > 59KVi

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

Dave, Is there a way to do this but have it only happen if there's nothing after the Alt Enter?  For example, if there were 4 rows but the last one didn't have anything in it, only the last one would be gone?  Example below: Entered Test Test2 Test3 Formula Result Test Test2 Test3 Thabk

RE: $$Excel-Macros$$ Excel VBA : Unique Values

Hi Sundarvelan, I don't know how to do this without VBA because of the duplicates, sorry. Regards - Dave. Date: Mon, 9 Aug 2010 22:58:21 +0530 Subject: Re: $$Excel-Macros$$ Excel VBA : Unique Values From: nsund...@gmail.com To: excel-macros@googlegroups.com Thank you So much!!! Dave. Cou

$$Excel-Macros$$ Sharing Data Between Sheets

Hi, I have a data table like this in a sheet: *Item* supplierItem1 ahoelting item2 cip item3 ahoelting item4 greko item5 herroits item6 cip item7 ahoelting and I have a few other sheets named ahoelting, cip, etc. This table also has a column named "In Stock" and this column is populated