Hello,
I have this code to delete duplicates based on highest value in column "B"
I need from formula to check, if in columns "C", "D" or "E" are any entries and merge them to row with highest value in column "B" before deleting the rows.
Please Login or Register to view this content.
Last edited by misop; 09-13-2012 at 03:00 PM.
Column A B C D E F ... at all 94 columns
A0001 1 AAAAAA asdsdas
B0001 1 CCCCCC 01.01.2010 DDDDD
C0001 1
A0015 1
A0001 2 01.01.2000 BBBBBB
A0002 1
B0001 2
A0001 3 xxxxxx
In the end I want to have this:
Column A B C D E F
C0001 1
A0015 1
A0002 1
B0001 2 CCCCCC 01.01.2010 DDDDD
A0001 3 AAAAAA 01.01.2000 BBBBBB xxxxxx
no one can help me? or it is impossible?
Do you have a excel sample file that you can upload?
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
of course, here it is
Last edited by misop; 09-13-2012 at 04:34 AM.
So only columns C, D and E should be merged with the highest value row?
yes, i want to merge only this 3 columns, other columns will be only from the row with highest number in column B
Try this code
Put it in a standard module.Please Login or Register to view this content.
GREAT IT WORKS...
only thing I should done now is, after deleting rows, sort data from oldest to newest: date will be in column "CO"
Last edited by misop; 09-12-2012 at 03:32 PM.
Now I get this error: Run-time error 1004: The sort reference is not valid. Make sure that its within the data you want to sort, and the first Sort Box isnt the same or blank
it highligt this part:
Please Login or Register to view this content.
Last edited by misop; 09-13-2012 at 05:51 AM.
Your sort code should be -
Please Login or Register to view this content.
Here is whole code with sorting on column CO too:
Please Login or Register to view this content.
Last edited by misop; 09-13-2012 at 06:21 AM.
One time it works and when i try it again... it gave me the same error
Your sort shows that its sorting on A & B columns. You need to change this code to sort on column CO. So you only need one -
What is this code that you have below -Please Login or Register to view this content.
Please Login or Register to view this content.
It is good to first time sort on columns A & B so i think that code is correct
After cleraing database (deleting and marging rows) i need again sort data on column CO and that makes this code:
Please Login or Register to view this content.
line is incomplete. You need to put in the row number for CO. You have only put the column.Please Login or Register to view this content.
that was my mystake, I repaired that after posting here...
I give sample of my data and try to sort them, delete rows... with code you gave me... button "Tlačidlo"
It works for me every second or third thry... i dont understand... sometimes it game me error, sometimes not..
Is your file in excel 2003 or 2010?
in file format 2003, but i am workin with it in 2013
The file is in 2003, right? So the sort code will not be compatible for excel 2003.
yes it is in 2003... why it is not compatible... is that possible to write macro for 2003? I think it can work than in 2003, 2007, 2010, 2013 right?
The sorting code in 2003 is completely different than 2007 and onwards with respect to syntax.
This is a sample of a 2003 sort code
Please Login or Register to view this content.
so i must replace this code:
with this code?Please Login or Register to view this content.
Please Login or Register to view this content.
Yes and change the cell references where required.
with this code:
it only sort data, but it dont delete any row...Please Login or Register to view this content.
I think I found solution
it seems to workPlease Login or Register to view this content.
You need to edit this code slightly. Change this fromtoPlease Login or Register to view this content.
Note: If you do not make out the changes, i have put "." before the ranges, since you have the With statement before them.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks