Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I show a formula's result on a worksheet tab?
Can anyone help? I would like to be able to see a result by just glancing at
the tabs in a workbook - perhaps lazy by not reviewing a summary page but quicker to ingest! |
#2
|
|||
|
|||
You don't give much to go on, but here's one way:
Assume you want to see the sum of Sheet1, cell A1 and Sheet4, cell J10 in the tab of Sheet4. Put this in the ThisWorkbook code module: Private Sub Workbook_SheetCalculate(ByVal Sh As Object) Dim dTemp As Double With Sheet4 On Error Resume Next dTemp = Sheet1.Range("A1").Value + .Range("J10").Value .Name = CStr(dTemp) If Not .Name = dTemp Then .Name = "~~~ERROR!~~~" On Error GoTo 0 End With End Sub If you're not familiar with macros, see http://www.mvps.org/dmcritchie/excel/getstarted.htm Note that you need to use the Sheets' code names (as shown in the Project Explorer) if you're changing the tab names of the sheets of interest. In article , ukplay wrote: Can anyone help? I would like to be able to see a result by just glancing at the tabs in a workbook - perhaps lazy by not reviewing a summary page but quicker to ingest! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic formulas including worksheet references | Excel Worksheet Functions | |||
show text after formulas | Excel Discussion (Misc queries) | |||
Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Formulas appear in cell instead of formula result | Excel Worksheet Functions |