RE: $$Excel-Macros$$ Macro to remove repeats and merge

2011-09-02 Thread Rajan_Verma
I think Remove duplicate is the Best option : -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gaetan M Sent: Wednesday, August 31, 2011 6:00 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Macro to remove repeats

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-09-02 Thread NOORAIN ANSARI
Dear Gaetan, Please see attached sheet if it help to u... ** *Sub Remove_Duplcate_and_Merge() **Dim i, j As Integer Application.ScreenUpdating = False Application.DisplayAlerts = False For i = 1 To Sheet1.UsedRange.Rows.Count If Sheet1.Cells(i, 1).Value = Sheet1.Cells(i, 2).Value Then

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread dguillett1
Sent: Tuesday, August 30, 2011 4:14 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro to remove repeats and merge I have the following: Column A B C D E F 12722 12722 51.5 64.89 RNLO X 12723 12723 51.5 64.89 RNLO X Would you

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread dguillett1
, August 30, 2011 4:14 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro to remove repeats and merge I have the following: Column A B C D E F 12722 12722 51.5 64.89 RNLO X 12723 12723 51.5 64.89 RNLO X Would you have

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread Gaetan M
ok thanks but I what i was wondering is if there is a possibility to run a macro to remove the prior line and combine them. I have a large amount of data and I need to compile it. So what i need to do is for everytime 2 or more items in column E are the same, they are merged and B2 takes the spot

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread dguillett1
: $$Excel-Macros$$ Macro to remove repeats and merge ok thanks but I what i was wondering is if there is a possibility to run a macro to remove the prior line and combine them. I have a large amount of data and I need to compile it. So what i need to do is for everytime 2 or more items in column E

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread Gaetan M
) = Left(Cells(i, 1), 4) Then Rows(i).Delete Next i End Sub === -Original Message- From: Gaetan M Sent: Tuesday, August 30, 2011 4:14 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro to remove repeats and merge I have the following: Column A      B

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-31 Thread dguillett1
-1 If Left(Cells(i + 1, 1), 4) = Left(Cells(i, 1), 4) Then Rows(i).Delete Next i End Sub === -Original Message- From: Gaetan M Sent: Tuesday, August 30, 2011 4:14 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro to remove repeats and merge I have the following

$$Excel-Macros$$ Macro to remove repeats and merge

2011-08-30 Thread Gaetan M
I have the following: Column A B C D E F 12722 12722 51.564.89 RNLOX 12723 12723 51.564.89 RNLOX Would you have the solution to replace B1 by B2 and delete row 2 once completed since they have been

Re: $$Excel-Macros$$ Macro to remove repeats and merge

2011-08-30 Thread Venkat CV
Hi, You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M gaetan.me...@wanadoo.fr wrote: I have the following: Column A B C D E F 12722