auto update a cell

  1. S

    If a cell changes, multiply it by another cell.

    This may be tricky. I have a spreadsheet with several columns of numbers for sales data. If the cost of an item goes up, I want to be able to enter that cost and have it automatically multiplied by a markup factor contained in another cell. For this instance, my range is C3:L25 and the...
  2. A

    partial vlookup and auto update the incomplete word that contains "-"

    Hello, I've search threads with tags autocomplete and vlookup but haven't found some similarities with what I need, so hopefully someone can help. this is my 2nd post, please go gentle on me if this question has already been asked. What I would like to find is a way for auto updating a part of...
  3. O

    Auto Update Last Modified date when row is edited

    Hi excel wizards! I'm looking for some assistance with a sheet to track up to 200 simultaneous projects by automatically updating the date in a cell when any cell in the row to the right of the date cell is modified. I have done lots of digging online and I understand that I will need a VBA...
  4. M

    Excel Macro Help

    HI, I have the following solution to come up with: I have a worksheet that needs to check for Column F having an entry of Yes or No, if it is Yes then auto-populate Column J with a 1, If it is a No then auto-populate Column J with a 0. I probably need to go through the Pseudocode first...

Watch MrExcel Video

This Week's Hot Topics

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
Top