I have a spreadsheet. I update Cell B1,B2 and B3 every two minutes automatically based off share prices.
Now I want cell C4 to update the data of the previous cells as well every two minutes.
How can I automate this?
Thank you for the reply.
i have share price feeds of different markets imported by excel from the web(web query source yahoo finance).
Like in B1 ,Aaple share price is cauto fed, B2 Eur Usd is auto fed after every 2 minutes automatically and so on,
what i want is ,In cell C4 i want the price of B1 and B2 to be updated every 2 minutes automatically.
With best regards,
Excel Calculation Counter ??
Change when and how formulas are recalculated
manually you can do it i think if you press F9?
Excel 2003: Tools-Options-Calculation-Automatic.
Excel 2007: Office button-Excel options-Formulas-Workbook Calculation-Automatic.
Excel 2010: File-Options-Formulas-Workbook Calculation-Automatic.
Just turn on autocalculate (if it is off) for the sheet. Any time any value in any cell changes, it will automatically update all other cells on the sheet.
Bingo!!! Absolutely the correct answer and a simple task for MS Excel.