deleting cells

  1. P

    Deleting data from a worksheet

    Hi, So I am trying to build a macro to pull data from one sheet in a workbook sorted by the data in column M. I currently have the macro written such that it pulls all of the data over to each of the new sheets and then deleting the info that is not applicable. Unfortunately the deleting is...
  2. S

    HELP NEEDED - Deleting all cells from a list that contain any cells from another list for 2010 EXCEL

    Hi Guys, I am in need of a little help with a fairly simple task i am having a problem with. I have 2 lists of names, lets call them "large list' in sheet 1 and "small list" in sheet 2. The small list contains names that are in the large list that i want deleted from the large list leaving...
  3. G

    formatting and deleting cells and rows from a txt import in excel

    I believe I have exhausted all the searches I could do on this subject and since I have not solved my first problem I hope I can post and get an answer for both of my issues... Background: I recieve a report from an old database in email as a message, I copy that message to word and save it as...
  4. E

    Deleting cell contents which contain negative values

    Hi I'm trying to clear the content of cells in a large table that contain a negative value using some VBA. Any help greatly appreciated. Thanks Emilie
  5. E

    Delete row that contains text VBA

    Hi I hope someone can help me out I'm very new to VBA! I have a data set (set of results) that contains text and numbers, occasionally there is a row that just has one cell of text in (a three letter abbreviation that could be ONE OF 17 different abbreviations - OCS, DSQ, BFD, ARB, DGM, DNC...
  6. S

    Using Macros to delete cells & rows based on specific criteria

    Hello, Each week I run a report that produces over 2,000 rows. I have to manually go through and delete things, by the time I am done, there may only be 320 rows left. I would apply a recorded macro, but the report is not consistent each week. There may be more or fewer rows depending on the...
  7. P

    Delete just cells and shift up instead of delete entire row

    OK here's my dilemna. I can delete the row if my condition is met (Columns C = "Gone"), but I need to instead make a selection and delete just those cells and shift up. Basically if cell C in a row = Gone, then offset (-2, 12) as selected cells, then delete shiftup. I've gotten close to...
  8. C

    Clear contents and deleting empty cells

    I need a vba that could clear the cells that are in yellow and leave all the white cells then shift up. Any help is appreciated! <TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=410 border=0><COLGROUP><COL style="WIDTH: 123pt; mso-width-source...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top