auto calculate

  1. K

    Excel Macro - If Cell contains a certain word then run the formula

    NOTE:I'm new to this forum & to coding in Excel & English isn't my first language so excuse me if I'm bad at explaining things I will do my best. :( Hello, there my name is Kovela. I am a financial analyst for a new company. I need to figure out a code that would help me in summary "If Cell...
  2. J

    Auto Insert Row & Sum the Above Cells Excel Macro

    In my Excel sheet I have values from Column A to Q. Column A is the Serial number Such as 1 2 3.....starting values from A6 as 1. Column G is filled in without having Blank rows. Example Column A6 is 1 & Again column A8 is 2. Hence I want to insert a Row in 8th row & will have a Text TOTAL in...
  3. M

    Excel 2017 not auto calculating some rows in a sheet

    Hi all Having a problem with a tab in my excel workbook that doesn't autocalculate some rows. The equations in those rows are valid but they do not update when the data they are reading from is changed. Pressing calculate now doesn't update the result of the equation either. The only way I...
  4. J

    How to get UDF to calculate on WB open?

    Hey all, I have this UDF to emulate the Subtotal function for calculating the median on visible cells only within a range, but it seems to rarely (if ever) calculate when I open the workbook... I have to enter or tab through each cell containing the function in order to get a value rather than...
  5. E

    Auto picking and pasting random samples from one sheet to another sheet.

    Hey guys, I'm trying to pick random samples from the sheet which contains huge data ( many people data ). I'm new to <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial...
  6. A

    Categories in Data Tables?

    Hi everyone, So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look...
  7. W

    Automated Timecard Calculations - Not adjusting RT and OT

    The formulas I have in the sheet were working great, until I worked a day with less than 8 hours. The timecard is not correctly totaling the RT and the OT. I tried changing the formula to take from the total in Column F, which it didnt like because it created a circular logic. Any suggestions...
  8. R

    Calculate columns automatically based on the first column

    Hi Dear All, I have an excel sheet that is feeded by an Access table, so the number of the rows is variable. I am looking for a code that calculate IDs based on the first ID (123 in this example). So, the idea is to replace 1000 with (123 + 1) and 2000 with (123 + 1 +1) .. to the last column...
  9. J

    Auto correct/populate drop downs

    Hi all, First time poster - bare with me please! I have a spreadsheet that is very dependent on selected location. I currently have data-validation dropdown lists for continent, country and city - the formula for each list is =indirect('previous dropdown'); ie the 'Continent' dropdown is in...
  10. J

    AutoCell Referencing

    I am trying to create a series of documents which will auto reference themselves; these documents are of financial nature and the query begins with one level of the series - auto tax references. In one sheet of this tax calculator I have copied an auto-updating cell reference to other...
  11. C

    Having Two Different Tables, and Deducting Qty Just by Recalling Item Name and Putting away Sold Qty

    I have 2 sheets... both have tables... One have Item Names in one column and Remaining Qty in the next column... the Other have Items Names is one column and Qty Sold in the next column... I want both this tables to get attached with each other in a way that when I put item name in the first...
  12. C

    Need some assistance with Excel

    I am in need with some assistance with Excel. I am looking to do an inventory for mileage on fleet trucks I have on my construction site. I have basic knowledge of building a chart displaying all the vehicles the unit #'s and the mileage. What I was wondering is there a format I can use to...
  13. E

    XL 2010: Auto-populating data (pulled from a closed workbook) based on a single entry into a different workbook.

    I'm not sure if this can be done, I've been looking into linking workbooks, connections, etc. Any help would be much appreciated. Here's what I want to happen: Several users complete an excel form (Form) where only certain cells are unlocked for them to enter data. One of these cells is a...
  14. G

    Goal seek VBA with IF statements

    I am trying to run an automatic goal seek via a button and am not sure what the Macro <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250...
  15. L

    Auto/manual calculation and F9

    How to keep auto calculate spreadsheets from taking over manual calculate spreadsheets. When i have an auto calculate spreadsheet open, then open a manual calculate spreadsheet, the auto calculate function takes over. Other than the obvious - don't open them both at the same time... is there...

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