Re: $$Excel-Macros$$ Re: Removing duplicates within cell

2015-02-24 Thread Chandra Shekar
Hello Michael, Thanks for the solution. Regards, Chandru On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth wrote: > Hi Chandru, > > Please find the attached macro files for Removing Duplicates within the > cell. > > Kindly let me know, if you have any queries. > > Regards, > MV > > On Tuesday,

Re: $$Excel-Macros$$ Removing duplicates within cell

2015-02-24 Thread Chandra Shekar
Hi, Correct Paul it should be f, g, a, b. if possible please provide solution for both. Regards, Chandru On Wed, Feb 25, 2015 at 11:51 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Thanks for your reply. If possible both the steps Macro as well using > formulas. > > Regar

Re: $$Excel-Macros$$ Removing duplicates within cell

2015-02-24 Thread Chandra Shekar
Hi, Thanks for your reply. If possible both the steps Macro as well using formulas. Regards, Chandru On Tue, Feb 24, 2015 at 6:07 PM, Paul Schreiner wrote: > What type of solution are you looking for: > VBA macro? > steps in Excel? > > Do you know how to use/maintain a VBA macro if one is pro

RE: $$Excel-Macros$$ FW: Help required

2015-02-24 Thread Neeraj
Thanks Ganesh!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Tuesday, February 24, 2015 12:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ FW: Help required Dear neeraj, PFA, Regards, Ganesh N O

Re: $$Excel-Macros$$ Re: mouseover on list of item in combobox

2015-02-24 Thread Sal Sal
hummm but i dont see any and paticular effect, simple a list of value of combo, nomouse over on each item. Tks for code in other case 2015-02-23 22:36 GMT+01:00 michael vinoth : > *Hi Sal Sal,* > > Please find the attached macro file. > > Regards, > MV > > > On Monday, February 23, 2015 at 10

$$Excel-Macros$$ Re: Export Data on new Sheet with same Id of that column

2015-02-24 Thread michael vinoth
Hi Harpreet Singh, Please find the attached macro file. Regards, MV On Saturday, February 21, 2015 at 1:35:35 PM UTC+5:30, Harpreet Singh wrote: > First of all let me tell you all that i am totally new to Excel. I never > used it before.. I am in a little trouble, so i need help of your guyz..

$$Excel-Macros$$ Re: Removing duplicates within cell

2015-02-24 Thread michael vinoth
Hi Chandru, Please find the attached macro files for Removing Duplicates within the cell. Kindly let me know, if you have any queries. Regards, MV On Tuesday, February 24, 2015 at 3:47:00 PM UTC+5:30, Chandru wrote: > Hello, > > How to remove duplicates within a cell using VBA? > > Please

Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread tony . kilduff
Thanks Paul, that worked a charm. I could (and probably should) leave it there - I recorded the steps and I can just drop them into my code as is. But, I'm curious. Here's part of what I recorded ... With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array( _ "OLEDB;Provider=Microsoft.AC

Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread Paul Schreiner
There are many, many (many) ways of retrieving data from a database. What YOUR code: Workbooks.OpenDatabase Filename:= _ "G:\Work Program\2015\Temp.accdb", is doing is actually opening the actual database in Excel, instead of retrieving the data. Instead, you could try: On a blank sheet (wi

Re: $$Excel-Macros$$ Converting excel files to .txt format with delimiter comma

2015-02-24 Thread Muneera Sabana
Hi Ashish, I want to open the excel file & then convert to text. Can I add this code within my macro code? On Mon, Feb 23, 2015 at 5:32 PM, ashish koul wrote: > Option Explicit > Sub export_range_delimit() > > Dim arr As Variant > Dim fs As Object > Dim delimittxt > Dim i As Lo

Re: $$Excel-Macros$$ Removing duplicates within cell

2015-02-24 Thread Paul Schreiner
What type of solution are you looking for: VBA macro? steps in Excel? Do you know how to use/maintain a VBA macro if one is provided? in your example: f,g,a,b,f would result in f,g,a,b not f,g,a Paul - “Do all the good you can, By all the means you c

$$Excel-Macros$$ Re: Help required

2015-02-24 Thread Maciej Piotrowicz
Hello Correct me if mistaken. You want to sum time in column 1 with time in column 2 in column 3 in format like hh hrs mm minute. If yes in column 3 add simply column 1 and column 2 (you can round it). Change format of result by pressing ctrl+1 and typing in custom type: *hh "hrs" mm "minute"*

$$Excel-Macros$$ Removing duplicates within cell

2015-02-24 Thread Chandra Shekar
Hello, How to remove duplicates within a cell using VBA? Please find attached sample file for the same. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/di

Re: $$Excel-Macros$$ Dynamic chart between data range

2015-02-24 Thread amar takale
Can any body help me On Mon, Feb 23, 2015 at 12:10 PM, amar takale wrote: > Dear experts > > I want to update chart as per date change in cell I3 & J3.means between > date range. i think it done by offset formula through name range. > > pls guide me > > Regards > Amar > > -- > Are you =EXP(E:RT)

$$Excel-Macros$$ How to read crypt7/8 files

2015-02-24 Thread Nitin Updhyay
Dear all, Pls help me on this how can we read crypt files in excel or txt. Regards Nitin upadhyay -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Please solve this

2015-02-24 Thread Ashish Bhalara
Hello, Kindly explain particular detail what result you need, there are not any logic fulfill from your sum in output, though I try to understand your output and solve it, see attached file. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spre