automatically change

  1. D

    Automatically update date within a formula

    Hi, I have a sales table which shows how many sales have been made using a formula that Counts data from another report. Example: =COUNTIFS('Sales Report'!$D:$D,"upgrade paperwork sent",'Sales Report'!$K:$K,"Mrs Brown",'Sales Report'!$G:$G,"42838") 42838 being the raw data for the date I want...
  2. D

    generate multiple excel files (forms) from excel spreadsheet

    Hi -- I am hoping we can find a solution to this problem. Across the country we are creating project worksheets, each project has multiple sites. Each site has its own spreadsheet file named projectname-Sitename-date. Currently we create each spreadsheet file and fill in the data (its a template...
  3. N

    Automatically Change String Value of a Cell Based on the String Value of Another Cell

    Hi Forum, I've had a tough time searching for a solution with Google. I don't quite know how else to phrase it. I have an Excel workbook where users input data. In two of the columns, D and E, users select from in-cell dropdowns (data validation). Each column has three selections to choose...
  4. T

    Cell Alignment Automatically Changing

    Hello, I have a spreadsheet that is center aligned, however, every time I scroll over the cells it changes them to be right aligned. It does this for every other line so in other words it only changes every other row into the right alignment. [/IMG]
  5. S

    Adjusting for inflation on Excel

    So I have an excel problem (first time user) and I have to adjust for inflation for a fortnightly payment. So the payment comes in every fortnight and its $900. Inflation is estimated approx. 4% and its to occur on a yearly basis on and after 1/07/2014 (so the next one would be 1/07/2015 and...
  6. D

    Auto Run Macros when cell range is changed

    I am looking for a way to run my macro automatically when a specific range of cells has any input change. If cell range S11:S34 on Sheet1 has any changes I would like to run my PartBalance macro which affects Sheet2 I have tried using the following: Private Sub Worksheet_SelectionChange(ByVal...
  7. C

    Change Tab color based on tab name

    Hi All, Im working on a worksheet for multiple evaluation forms. I have 3 types of forms: OTO TRNG RTR I need a code or something to make the tab/sheet colors change once the type of form is declared on the tab name. Example: If I put "OTO Nov 17" as the tab name, it will change the tab...

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