LinkBack URL
About LinkBacks
How would i go about writing a vba code line that loops through a range and deletes rows where the cell value does not equal the value of the cell above or below?
Macro Help need to delete rows with certain criteria
How would i go about writing a vba code line that loops through a range and deletes rows where the cell value does not equal the value of the cell above or below?
What is the range through which you want to loop?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
A11 through Until A cell is blank
Is there data in A10 and do you want to delete row 11 if it meets your criteria? What would you like to do with the last used row in column A? Since the cell below the last used cell in column A will always be blank, the row in that last used cell will always be deleted.
I want it so as long as it matches at least one of the cells above or below. so as long as A11 has a match below it will not delete and as long as the last cell matches the cell above it will not delete.
Try:
Please Login or Register to view this content.
this is perfect! thank you, now what if i want to also have it remove duplicate "MDU Self monitored" charges From E11 until there is no value in the cell but remove the cell with the lesser value shown in cell I?
I'm sorry but I don't follow. Could you attach a copy of your file and explain what you want to do in detail referring to specific cells, rows and columns using a few examples from your data?
Nevermind, How would i do a macro that starts at A11 that deletes duplicates where if Row A of the Column and row E match with any other rows. Sorry i cannot provide samples as it is a specific bill that cannot be disclosed.
Perhaps a de-sensitized file?
DeSensitized.PNG
Not sure if this attached. I don't want any of the equipment fees to be deleted. Just the duplicate MDU Self monitored for the specific address
I'm sorry for being a "pain" but it's hard to work with a picture. Could you please attach the file? Looking at the second image, you would want to remove rows 19, 28, 31 and 34. Is that correct? What do you mean by "I don't want any of the equipment fees to be deleted."? In which column are the equipment fees? It would help if you could include a second sheet that shows the desired result in the copy of the file you post.
Re: Macro Help need to delete rows with certain criteria
the highlighted fields are the ones i want the code to use as reference as you can see there are 2 rows that say "Apartment 9" and "MDU Self Monitored Security" I need it to remove the first one of these if there are duplicates (See Outcome tab). In Row E there will potentially be duplicate equipment charges, but i do not want it to delete these duplicates. I only want the duplicate MDU Self Monitored Security charges to be deleted.
the attachment button does not function
To add an attachment, click the "Go Advanced" button. Then scroll down a bit and click "Manage Attachments".
Mis-posted. Sorry.
Last edited by Mumps1; 07-02-2019 at 05:10 PM.
I need some clarification. Comparing the 2 files, the first row you want to remove is row 18 which has "Apartment 8" in column A and "MDU Self Monitored Security" in column E. However, in the Outcome file, "Apartment 8" still appears in column A. The same is true for the other rows containing "MDU Self Monitored Security ". In the De-sensitized file, Rows 39 to 43 contain "220 Riverside Ave Unit 651" in column A. I can understand why row 42 (duplicate row) would be deleted but why are rows 39 to 41 and row 43 also deleted? Those rows don't appear in the Outcome file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks