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

Read hear as Hurt 2009/12/24 Vinod N > Hi Rf1234, > > I dint mean to hear ur feelings Dave's reply was more appropriate for > my requirement.. i need to check the alternative given by you... > > Anyways.. Thanks a Tonn!!! > > Vinod N > > On Thu, Dec 24, 2009 at 10:51 AM, Dave Bonallack < > d

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

Hi Rf1234, I dint mean to hear ur feelings Dave's reply was more appropriate for my requirement.. i need to check the alternative given by you... Anyways.. Thanks a Tonn!!! Vinod N On Thu, Dec 24, 2009 at 10:51 AM, Dave Bonallack wrote: > Huh? > > -- > Date: Th

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

hi friend i think we talking about vba macro and function. unable to understand huh? On Thu, Dec 24, 2009 at 10:51 AM, Dave Bonallack wrote: > Huh? > > -- > Date: Thu, 24 Dec 2009 10:24:02 +0530 > > Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture nume

Re: $$Excel-Macros$$ Database Connecting problem

u can download Retrieve_data_from_MS_access.rar

Re: $$Excel-Macros$$ if statements with several matching values.

Do You want to Use specific VBA coding or else You can use this formula from Dilip directly like this in VBA: Activecell.formula = "=IF(AND(A2="abcdCust",LEN(B2)= > > 6),0&B2,IF(AND(A2="xyzzCust",LEN(B2)=8),LEFT(­B2,4)&"-"&RIGHT(B2,4),""))" On Thu, Dec 24, 2009 at 12:44 AM, mike wrote: > Well

Re: $$Excel-Macros$$ Find specified word is contained in a text string

Hi Mahesh, Use this function along with the Exactwordinstring function. Function checkthis(Text As String, rng As Range) For Each entry In rng result = ExactWordInString(Text, entry.Value) If result Then checkthis = entry.Offset(0, 1).Value End If Next End Function Now in cell h2 write the formu

Re: $$Excel-Macros$$ Database Connecting problem

Hi abhishek, i dont know that it was working or not. my os is 32 bit.. Mahavir 2009/12/23 Abhishek Jain > Hi Mahavir, > > > Was the connection working in the past ? > > Is the OS you are using is 64 bit ? > > Krgrds, > > Aj > > On Wed, Dec 23, 2009 at 12:00 AM, Mahavir Bhardwaj < > virbhardw

Re: $$Excel-Macros$$ Help on macros - Mail sent from Excel

Hi Vinod, Can you try using vbnewline in .htmlbody directly instead of using it in strbody? On Wed, Dec 23, 2009 at 10:29 PM, Vinod N wrote: > Hi Excel Gurus, > > In the attached file, the following string is not working > > strbody = "Please clarify the following:" & vbNewLine > > Initially, t

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

Huh? Date: Thu, 24 Dec 2009 10:24:02 +0530 Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values From: rfhyd1...@gmail.com To: excel-macros@googlegroups.com :) at least say thanks who help u out in problem On Thu, Dec 24, 2009 at 5:53 AM, Dave Bonallack wrote: You'

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

:) at least say thanks who help u out in problem On Thu, Dec 24, 2009 at 5:53 AM, Dave Bonallack wrote: > You're welcome. > > -- > Date: Wed, 23 Dec 2009 21:21:00 +0530 > Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric > values > > From: nvino..

Re: $$Excel-Macros$$ if statements with several matching values.

Well that works if using a formula, how about implementing that using VBA? On Dec 6, 6:17 am, Dilip Pandey wrote: > Dear Mike, > > Below is the formula for your requirement. > > =IF(AND(A2="abcdCust",LEN(B2)=6),0&B2,IF(AND(A2="xyzzCust",LEN(B2)=8),LEFT(­B2,4)&"-"&RIGHT(B2,4),"")) > > Solved workb

Re: $$Excel-Macros$$ how to Copy data from worksheet into another workbook sheet(Very Urgent)

Hi Karthik, What is the data that you want to copy and into which shet you want to copy. On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik wrote: > Hi > any can help me , I need to copy the data from report2.xls to paybill.xls > sheet , How to do with VBA, Could any help , ITs very urgent > >

$$Excel-Macros$$ Find specified word is contained in a text string

Dear All i need help to modify below mention user define function. i got this code on below mention link. i herewith attach the excel sheet. I will appreciate any help on this. http://spreadsheetpage.com/index.php/tip/is_a_particular_word_contained_in_a_text_sring I want to modify this user defin

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

You're welcome. Date: Wed, 23 Dec 2009 21:21:00 +0530 Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values From: nvino...@gmail.com To: excel-macros@googlegroups.com Thanks Dave This works awesome .. Vinod On Wed, Dec 23, 2009 at 12:40 PM, Dave Bonallack wrot

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

Thanks Dave This works awesome .. Vinod 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 a > list with duplicates, using a single line ov VBA. It doesn't matter what > kind of data is in the orig

Re: $$Excel-Macros$$ Month/Day/Year vs Day/Month/Year

For this, I have to repeat my usual "diatribe" about Excel and "dates". In Excel, there is not such thing as a date. It's only a number. The number of days since 1/1/1900. In fact, there is no time. time is merely the fractional part of a day. Therefore, Today, (12/23/2009) has been 40170 days sinc

$$Excel-Macros$$ Month/Day/Year vs Day/Month/Year

I have a combo box pulling a list that is day/month/Year, however when the text in the combo is pushed back onto the spread sheet the dates are month/day/year. How can I make the listing consistant? Mayby there is an example someone has that I can see the code. Thanks Michael Sorry, if this was

Re: $$Excel-Macros$$ Database Connecting problem

Hi Mahavir, > Was the connection working in the past ? > Is the OS you are using is 64 bit ? Krgrds, Aj On Wed, Dec 23, 2009 at 12:00 AM, Mahavir Bhardwaj wrote: > Dear All, > > I am tring to import some data from other applications such as Access & > Tally but when i connect it to them > > *

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

Hi Dave, I am also try to select "List", but it showing the error. Please attached the workbook with the solution. On Wed, Dec 23, 2009 at 3:41 PM, Dave Bonallack wrote: > Hi Mahesh, > Firstly, unless TN, North, South, West, East, Dehli, Mumbai, Kolkata are > named ranges, those words should

$$Excel-Macros$$ List of available fonts

Hi, I want to list available fonts in the system and write text in each row in different font style name. Regards, Sameh -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and

Re: $$Excel-Macros$$ Copy specific Columns from 1 workbook to other workbook and iteratively in all worksheets

Any takers for this call? On Fri, Dec 18, 2009 at 3:32 PM, kamal shah wrote: > Hello Excel Gurus, > > I have a task of copying data (specific column from specific place) to a > new work book's worksheet at specific column from specific cell. > I have attached both work books for reference here

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

suppose in sheet1 range a1 u have a value like a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com a...@gmail.com ab...@gmail.com ab...@gmail.com ab...@gmail.com ab...@gmail.com ab...@gmail.com a...@yahoomail.com a...@yahoomail.

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

after getting unique value u can select a unique list. insert-->name-->define(now name and range of unique values) data-->validation-->allow-->list(name of list which u define in insert name define) your unique data list is ready now to work. On Wed, Dec 23, 2009 at 1:48 PM, rf1234 rf1234 w

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

'''distinct value string or numerical example 1 suppose in sheet1 range c1 u have a value January February March April May June January February March April May June January February March April January February March April May June output should be as follows Febru

Re: $$Excel-Macros$$ Help Required!

Hi Dilip, Good Afternoon! I just wanted to follow up with the below email. Any updated on this sir? Thanks & Regards, Sharma On 12/21/09, amrahs k wrote: > > Dear Dilip, > > Yes. Please go ahead with the revised solution since it looks perfect. > > Good job sir. Thanks a lot for your efforts.

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

hi umed check this one also On 12/23/09, Mahesh wrote: > 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(

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

hi vinod now check this one On 12/23/09, Vinod N wrote: > 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

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

Dear Gobet, Use following formula in the column B and drag it down. =RIGHT(A2,LEN(A2)-FIND("@",A2)+1) solved workbook is also attached. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Dec 22,

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

Hi Mahesh, Firstly, unless TN, North, South, West, East, Dehli, Mumbai, Kolkata are named ranges, those words should be in double quotes. =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(

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

Thanks From: harmeet.hew...@gmail.com Date: Wed, 23 Dec 2009 12:44:12 +0530 Subject: Re: $$Excel-Macros$$ GetUnique_Collection - to capture numeric values To: excel-macros@googlegroups.com Nice solution Dave.. :) Vinod,I hope that would help you. Thanks & Regards, Harmeet S