delete

Hi, I have a set of data which is exported into excel and I would like to automatically clean it up, so that it can be analysed. Once I select the entire data and sort it by column A, smallest to largest, it is then sorted by ticket number. I would then like to delete the rubbish on the...

Hi I've inherited a spreadsheet which has the following formula in it =HLOOKUP($AZ$3,$C$13:$P$53,@MATCH(C16,$C$15:$C$53,0)+2,FALSE) I'm happy with how it works but I've never seen the @MATCH phrase before, how does this differ from a straight MATCH statement ? I've tried deleting the @ and...

Is there a way to delete all named ranges from a selection? Here is the selection that I am trying to delete the named ranged from: Range("CompOverviewTable[[#Headers],[Competitor_one]]").Select Range(Selection, Selection.End(xlToRight)).Offset(-1, 0).Select

Hello, I was hoping that you could help me. I am trying to create this Employee benefit and vacation sheet which encompass all 12 months. Is there a way that I can create a table or something that will take the employees name and mirror to each worksheet (12 month), and if i add or delete an...

Hi All, I have the following loop code which filters my data for me. Once filtered, I want to keep the first top 5 rows of information and delete the rest. 'Loop to remove risks except for Top 5 x = 1 Do Until x = 52 Hospital =...

This seems ridiculously easy, but I cannot figure it out after many tries. Scenario: I have approx 35 columns (and rows of course) of data. I want to sequence through each column and delete any columns that meet a certain condition. Here's one of my many attempts that do not work. Example of...

good morning. long time viewer first time posting I am having difficulty with a code to delete an entire column base on top cell color. I supply a sample spreadhseet that has conditional formatting applied to highlight cell the equals A1. looking for an VBA code that i can assign to a active x...

hello, my code works but i need adjusted code when i press my macro ignore the empty rows from a19:e31 when delete these rows i suggest to be condition if a19 to a31 =0 then delete theses rows Sub TransferData() Dim Target As Range Dim LastRow As Long Dim R As Long...

im trying to delete all duplicates based on an ID in column F, except one (it doesn't matter which one I keep...ie it could be the first one, could be the last duplicate). trying to do this with a macro.

I'm looking for a script to delete any sheets that meets the following critera and without promtp: If sheets contains the text: "PrixMax" "6po" "Quote" Then deleted them Sheet name can be "PrixMax-250", "6po-Viny", "Quote-101018" Along with those sheets, my workbook contains a "Master" sheets...

I need to create a macro to delete rows if the value of a cell in column J is > or = to zero. The worksheet will vary in length, but will always use columns C through J. I know this is easy, but I can't get it right. Any help is greatly appreciated!

Ok so I am still a little new to macros so be gentle and please help it will be greatly appreciated. I have a macro and I want to delete any row that has the following text in a cell ISN or MTS across 35 tabs. current macro is only deleting ISN and MTS in active sheet. Sub Delete_Rows_ISN3()...

Hi guys, Any idea of a quick macro that will help me, I would like to delete all rows that doesn't contains at least IN, CH, EL on column A I do have many items in my stock list and I would like to keep all parts # that start by IN, CH and EL and delete all the rest that doesn't contains those...

Hello I need help with a bit of VBA code. I need the code to look at Column AI. Column AI can have a value of 0-7. If a Row in Column AI has a value of "0" check column Notes, If it is empty delete that Row. In the example below rows 4 & 5 would be deleted as they have an AI value = 0 and no...

Different issue to the previous one but vaguely related. I have charts set up in XL2013 32 bit, I've now got XL2016 64 bit with secondary axis. When I select a series and click (or press) delete, that series stays but all the others disappear. Doesn't matter which axis they are on. When I...

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Hello, I have a delete routine below that works great for my purpose. I am trying to stop users from deleting class after a certain date. I have the date field (ExpiredDate)in the tblClasses...

Hi I found this macro on here that runs a macro when the delete key is pressed on book opening. What I’m trying to do if poss is to have this but to be able to have it numerous times. I.E click on delete key run macro then push delete key run another macro and so on.... Can I do this...

If I wanted to replace all the 456 items in the column below, then the delete blank rows where the 456 items were, what menu do I use? <tbody> 142 996 456 123 456 226 456 225 456 </tbody>

This is like being a boat owner...there are always things that don't work right, but when most things work, it's really quite fun. I export a report out of a database. The 1st ROW is the header row. The 2nd row is where the data begins. The 6th column contains "Locations". The number of rows is...

I've gone and donked up my XLSB file somehow. i can access the workbook itself but i can not save it, nor can i access the VBA editor to fix whatever vba code is causing this in the first place. should i just delete it? I don't want to delete it. I don't have a current backup of it i do not...