range of columns

  1. M

    IF function referencing a range of cells and sheets

    Hello, I am setting up an expenses tracker for myself each month has it's own sheet and I have the last sheet tracking my Visa bill. What I want is if the Value in Column I in any of the sheets is "Visa" then copy the value in cell K to column E in the Visa Sheet in the form of a list. For...
    • mwgrace
    • Thread
    • budgeting if function range of cells range of columns
    • Replies: 4
    • Forum: Excel Questions
  2. B

    vba clear contents of range of columns with certain criteria

    hi Just wondering is it possible to clear cells multiple columns based on the criteria instead of column by column. For example: What i am trying to do i have a file with 28000 lines and want the macro to clear contents of the cells in columns W,X,Z,&AA that contain #N/A. Can this be done ...

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