Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

*Nice solution Dave.. :)* * * *Vinod,* *I hope that would help you. * Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack wrote: > Hi Vinod, > The attached shows how to create an instantly updated unique list from

RE: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values

Hi Vinod, The attached shows how to create an instantly updated unique list from a list with duplicates, using a single line ov VBA. It doesn't matter what kind of data is in the original list, or how long it is, or whether data is added later. The second line of code alphabetizes the unique l

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

Hi All, I have some problem in validation,(Creating drop down list) Please check the below mention formula. =IF($A3=$IU$2,TN,IF($A3=$IU$6,North,IF($A3=$IU$12,South,IF($A3=$IU$15,West,IF($A3=$IU$18,East,""&IF($A3=$IU5,Delhi,IF($A3=$IU$24,Mumbai,""))&IF($A3=$IU$25,Kolkata,"")) It working fine

Re: $$Excel-Macros$$ Removing or extracting lettres from List in Excel

Hi Andrea, Please find attached the solution in the excel file. Let me know if this is convinient for you. Thanks, Abhijeet Singh Akamai Technologies, Bangalore On Wed, Dec 23, 2009 at 8:32 AM, Harmeet Singh wrote: > PFA file > Thanks & Regards, > > Harmeet Singh > > Sent via BlackB

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

Hi Vinod, I was expecting the same output as Harmeet does. Can you send us an example file with the problem and the output you require in case the above doesnt help you. On Wed, Dec 23, 2009 at 8:27 AM, Harmeet Singh wrote: > Hi Vinod, > > Attaching a sample file. > If this is what u want, u migh

Re: $$Excel-Macros$$ Removing or extracting lettres from List in Excel

PFA file Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Tue, Dec 22, 2009 at 11:25 PM, Andre Gobet wrote: > Hello > > I've a list in Excel of about 1000 e-mail adresses from our internal > Database. Now i want to extract from this list only the domain names > to pu

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

Hi Vinod, Attaching a sample file. If this is what u want, u might wanna read my previous reply again else team would surely help u. Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Dec 23, 2009 at 2:53 AM, Vinod N wrote: > Hi Harmeet and Praveen, > > Thanks for the your

Fw: $$Excel-Macros$$ Re: Removing or extracting lettres from List in Excel

Hi Andre, There is an option in data menu...i.e. TEXT TO COLUMNS Just select the column and apply text to columnIn dialog boxselect delimited...mention "@" as separator in other field and select next ...next...finish... I hope it helps. You can also provide the sheet and we will do it fo

$$Excel-Macros$$ Re: Removing or extracting lettres from List in Excel

Hi Andre, There is an option in data menu...i.e. TEXT TO COLUMNS Just select the column and apply text to columnIn dialog boxselect delimited...mention "@" as separator in other field and select next ...next...finish... I hope it helps. You can also provide the sheet and we will do it fo

$$Excel-Macros$$ GetUnique_Collection - to capture numeric values

Hi Excel Gurus, The following macros complies a unique list from the Range("c21:c3020") and populated in Cell J3. However, it does not capture numerical values in the said range. Please help in modifiying the following macro where it can populate numeric as well as alphanumeric unique list Sub

Re: $$Excel-Macros$$ Need help on Validation

Hi Ankur, When "Tamilnadu" is selected, the Hub validation is not working... all other regions are working fine... Please check and revert.. A new learning about data validation Thanks a lott... Thanks Vinod N On Tue, Dec 22, 2009 at 3:44 PM, ankur wrote: > hi mahesh > > thanks for compli

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

Hi Harmeet and Praveen, Thanks for the your kind reply.. However, as i mentioned in my mail, the excel will be shared among many folks, who will be updating it simultaneously... As of now, I have already locked the formulas as mentioned by Praveen... This solution is available in one of the Excel

$$Excel-Macros$$ Database Connecting problem

Dear All, I am tring to import some data from other applications such as Access & Tally but when i connect it to them *[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified* Message is coming. Please give any solution. Mahavir Singh -- ---

$$Excel-Macros$$ Removing or extracting lettres from List in Excel

Hello I've a list in Excel of about 1000 e-mail adresses from our internal Database. Now i want to extract from this list only the domain names to put in to our Spam Filter for Whitelisting. Example List in Excel andre.go...@sesamnet.ch g...@bluewin.ch Now i'd like to have a list with only the D

RE: $$Excel-Macros$$ Extracting Numbers from the Text

Thanks paul, It is fantastically working as the way I have wanted; you have saved my time a lot. Regards, Selva -- *From:* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] *On Behalf Of *Paul Schreiner *Sent:* 21 December 2009 23:55 *To:* e

Re: $$Excel-Macros$$ Need help on Validation

hi mahesh thanks for compliment On 12/22/09, Mahesh wrote: > Hi Ankur, > > Thanx a lot... > > jst a simple word for this is "AWESOME" > > > > On Tue, Dec 22, 2009 at 11:19 AM, ankur wrote: > >> hi mahesh >> >> check the sheet, your query has been solved >> On 12/22/09, Mahesh wrote: >> > Hi

Re: $$Excel-Macros$$ Need help on Validation

Hi Ankur, Thanx a lot... jst a simple word for this is "AWESOME" On Tue, Dec 22, 2009 at 11:19 AM, ankur wrote: > hi mahesh > > check the sheet, your query has been solved > On 12/22/09, Mahesh wrote: > > Hi Friends, > > > > Attached herewith is the excel sheet for ur kind consideration.