btw

  1. R

    Button to copy value from one cell to another

    Greetings, Hoping someone can help with a script to make a Button (form control) copy the value from cell D4 and write it into the cell which is referenced as an absolute in cell E4. I'm not sure if I'm using the right button btw. Any help appreciated :-)
  2. L

    How to combine values from 2 columns

    I everyone! i have a problem, I want to create a single column from the combination of 2 others from diferent tables... these columns have a null value or a numerical value, like this: COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE...
  3. B

    how to find every cell that has a dependent

    I love the "Trace Dependents" function in Excel but it has a significant limitation. I have to click on every single cell individually to see if it has a dependent. Is there a way to select an entire range of cells and see which of them has one? I don't even need to know what the dependents...
  4. C

    Power query keep formatting after refresh

    I'm using PQ to get data from an external source. I'd like to change formatting for those records that are retrieved, but the formatting seems to disappear if I refresh. What are the recommended methods to keep the formatting during a refresh. BTW, I do have the checkbox checked that says...
  5. B

    Compare Two Sheet for Changes and Highlighted them

    Hi, I have two sheets, one is old and 2nd is a new version after some changes. I want to compare both sheets and want to highlight changes also if i can get old value and new values as well. could anyone help me please here . i dont prefer any 3rd party paid tool BTW.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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