deleting

Hi guys, I have decided to move this to a new thread as I think it may be useful for other users as well and it should be easier to find it like that. I have question related to one macro. I have a quite big file where rows are blocked (you can not add new line or delete existing one). On the...

So I have an annually acquired list of addresses that have backup generators onsite, along with contact info and company names, etc. There is a unique identifier, which is the address of the building, since these generators don't move locations often. Pretty much never. I have the list acquired...

Hello, I am looking for a VBA macro doing a specific job for which I am a bit struggling to code. I have a table where there is a string of characters in a column (essentially codes or references), and then I find them again later in another column (here C), sometimes in disorder : <tbody>...

I have a “Schedule Updates” subform to allow users to schedule future changes to a record on a specific date. These future changes populate tbl_ScheduledUpdates Simple Query qry_ScheduledUpdatesBase finds records <=Date() that now need to be changed. Update Query qry_ScheduledUpdates...

Meaning any emails in a column in Excel that have an email of aol.com, cs.com, and compuserve.com, I want to automatically delete and am wondering how do I do that? In addition, once they are automatically deleted I want the rest of the items in the column combined together so there are no empty...

Hello, Long time on-looker, first time poster here! I’m looking to write a Macro to delete multiple line items that pertaining to a common reference number, given that are not reflective of the latest update. For this problem, my data is downloaded periodically from a separate system and...

I was needing some code that would delete all empty rows. I need it to start at Row 3 and then find the last row of data and then delete all the empty rows in that range. Thanks Excel 2010

I am looking for VBA code that will allow me to delete a sheet using its Object Name and not the sheet name. The reason I need this is I download a document on a monthly basis where the name of sheet1 is different each month. I know the first sheet is always sheet1 then the new file name in the...

Have 100,000 rows of data. How can I delete, for example, all rows below row #20,000? Without doing it manually. Thanks, Bruce

I am transferring test results accross three computer systems - the first remote computer generates test results which are exported to an Excel sheet which I receive. I get test results in column A The results may vary in the number of characters. Numeric range will be between 1000.0 down to...

Hi, I am having a problem with deleting row data in excel. I want the macro to look at columns H and I, starting from row 17 and going down to row 500. I want the macro to delete the entire row if the both the values in H and I for that row are blank or 0. I'v been trying to edit the following...

i have a complex workbook. Recently, when I open it, it asks me if I want to update links. I never (that I know of) established any links to other workbooks. I see that a workbook is referenced in the "edit/links" menu, but I can find no way determine which cells, graphs, etc, in my workbook are...