auto adjust

  1. dejhantulip

    Dynamically adjusting SUM formula when adding rows at the bottom

    Hello everyone! I need some help figuring out how to work out a SUM formula that would "dynamically adjust" itself "auto adjust" itself when rows are added at the bottom of the sum range I have right now defined. Here is a screenshot illustration: So, for instance, as you can see I have a...
  2. S

    Automatically change year in Excel in available dates

    I am working on a daily stocks data that have dates that range from 2016 to 2000. The problem is the the data I have imported have converted all the years to "2016". The dates are in descending order. When the dates move from Januray to the next year's december, the year does not change...
  3. R

    Auto update column when ComboBox selection is made

    I've been putting together a macro that reads in cells from one specific row on <CODE>Sheet1</CODE> and places them onto a ComboBox on a <CODE>Sheet2</CODE> <CODE>|cellA | cellB | cellC | cellD | ... |cellZ | </CODE> </PRE>Once loaded to the ComboBox, whatever cell is selected there has it's...
  4. A

    Auto Resize Text

    Is there a way using VBA to make the text in a box, consisting of merged cells, auto fit the box? Example: The user enters a small amount of text in this large area of merged cells and runs AutoResizeText script. The script should resize the text to lets say a maximum of font size 16. On...
  5. C

    Format cell as Currency or Number based on value of another cell

    How can I format a cell to be either currency or a number, based on another cell value? For example, if A1="BP", then B1 should auto format as a Number when a value is entered. However, if A1="Flat fee", then B1 should auto format to be Currency when a value is entered. Cell A1 (whole column...

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