clearing data

  1. J

    Cell contents will not stay Deleted/Cleared of Data

    I am creating a spreadsheet where I am averaging numbers acrosscolumns B through K. An example of theformula is: (row 23) =IFERROR(AVERAGE(B23:K23),"0") **Formula created in column L** (row 24) =IFERROR(AVERAGE(B24:K24),”0”) **Formula created in column O** This...
  2. B

    Loosing data when unmerging cells

    Hello, Every week I recieve a data report in an excel file. I need to input this data in another program as a CSV file. This file is very hard to work with as there are multiple merged cells and many blank "spacer" rows and columns. I have tried to use a macro to unmerge all the cells and...
  3. G

    vba - ClearContents not working?

    Hi guys, just simple fast one - Any idea why if I put into my code only the first line below, clearing of the whole sheet does not work & if put another one then it is working.. ? Checked for protected, merged etc.. nothing such like this there.. ;o)...
  4. K

    vba code button to clear all; checkboxes, comboboxes, cells, counts, etc...

    Hi all, I am new to vba and i have tried to find a code on here for clearing my whole worksheet but i cant seem to find one which does the specifics i want to or does all the bits :) if i missed something id be very grateful for a thread link... Trying to create a new prf for my team, and i...
  5. A

    I have multiple rows of order data need to move daily to completed order tab

    I want to use column A if there is a number 1 in column A the order is complete and needs to be moved to the last empty row in the completed order tab. I just need a macro to move all completed orders once a day and clear the data that as been moved and move all other rows left to the top of the...

Some videos you may like

This Week's Hot Topics

Top