find and delete

Hi all, I saw a post by Trebor76 that has helped me to come a few steps forward, but i still have alot to solve and i need the help of some skilled VBA Excel users. I am quite at the basic level in Excel VBA and i will really be thankful if someone can take sometime to help me out I have data...

Hello, I have this extensive two columns list, many of the items in the list are duplicated is there a way to find and delete the complete row of each one of the duplicate in both columns?

Hi, I'm trying very hard to solve my own code issues but hours have turned to days on what should probably only be a few lines of script. My Code is below: Sub Edit_Dropdown_Lists() 'Hopefully this will be a worksheet event that when data is populated to the ProductFormulas_ 'sheet this macro...

i want to type something in "B1" and then if it is in sheet 1,2,5 it will get delete and then adds the word "changed" the next cell to the right in "Column B" Private Sub CommandButton2_Click() For Each cell In Range(Cells(1, "A"), Cells(Cells(Rows.Count, "A").End(xlUp).Row, "A"))...

Hello everyone, my laziness is catching up with me and I'm wondering if anyone has ever faced the following issue - I'd like to "subtract" text from a cell and keep the remainder (using a formula), though that might be too good to be true? Given the following original...

I am trying to write a code that finds the character "-" from cells in a range B3:H3 and clears the contents. I've seemed to hit a snag and could use some help

I am trying to create a drop down list that updates based on previous selections. When i say updates, i mean it deletes the selected information from an updated source list. For example: The source data on sheet 1 is: A2 Apple A3 Boy A4 Cat A5 Dog A6 Egg This are the column headings: Column C...

i have a report that creates many duplicate names. am using the Subtotals function so i can make the sheet only show 1 name. i then have "Grand Count" what i would like the macro do to is to Find Grand count and then delete everything from Grand count to the end of the sheet Grand count is...

Hello there, I have a simple question I have a work book contains our sales for 5 years Every sheet in this work book contains sales for one month. Sales is by costumer in each sheet. How can I create a simple macro that finds sales for a specific customer in every sheet, after finding the sales...