MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Show formula result in another sheet

  • Follow


sheet1 A:A contains a formula with some cells returning a value 

sheet2 A:A references sheet1 A:A with a simple formula:

=sheet1!A1

above formula filled down in sheet2 A:A

the problem is it is not showing the results from sheet1

anyone know why that should be?
0
Reply Utf 12/15/2009 10:12:01 PM 

Sorry false alarm, I had calculation set to manual. Results are coming back 
as they should. Red faces all round.


"Gotroots" wrote:

> sheet1 A:A contains a formula with some cells returning a value 
> 
> sheet2 A:A references sheet1 A:A with a simple formula:
> 
> =sheet1!A1
> 
> above formula filled down in sheet2 A:A
> 
> the problem is it is not showing the results from sheet1
> 
> anyone know why that should be?
0
Reply Utf 12/15/2009 10:18:03 PM

microsoft.public.excel.worksheet.functions 4936 articles. 39 followers.

1 Replies
859 Views

(page loaded in 0.597 seconds)

Similiar Articles:

Show formula result in another sheet - microsoft.public.excel ...
sheet1 A:A contains a formula with some cells returning a value sheet2 A:A references sheet1 A:A with a simple formula: =sheet1!A1 above for...

Why does forumula show in cell instead of formula result ...
Show formula result in another sheet - microsoft.public.excel ... Formula shows in cell instead of results (text reference ... Show formula result in another sheet ...

Testing for an Integer result in a formula - microsoft.public ...
Show formula result in another sheet - microsoft.public.excel ... Testing for an Integer result in a formula - microsoft.public ... Store formulas in Vlookups? ...

Store formulas in Vlookups? (another try ;) - microsoft.public ...
Show formula result in another sheet - microsoft.public.excel ... How Do I Display Formula Results In Another Cell ... well, but the results of the formulas are not shown ...

Reference text in a cell inside a formula to specify a sheet name ...
Show formula result in another sheet - microsoft.public.excel ... Show formula result in another sheet - microsoft.public.excel ... Reference text in a cell inside a ...

Formula shows in cell instead of results (text reference ...
Show formula result in another sheet - microsoft.public.excel ... Formula shows in cell instead of results (text reference ... Show formula result in another sheet ...

Formula shows as text - microsoft.public.excel.misc
Show formula result in another sheet - microsoft.public.excel ... Formula shows as text - microsoft.public.excel.misc Show formula result in another sheet - microsoft ...

bold text of referenced cell show in formula cell - microsoft ...
Formula shows in cell instead of results (text reference ... ... in a cell inside a formula to specify a sheet ... it act as text, or display the formula used in another cell ...

Formula results display only after pressing Enter key - microsoft ...
Formula results display only after pressing Enter key - microsoft ..... moving to ... The sheet has the following formula in it for a 2009 entry: =SUMIF(_6652[Constructed Key ...

Formula showing in cell - microsoft.public.excel.misc
Show formula result in another sheet - microsoft.public.excel ... Formula showing in cell - microsoft.public.excel.misc I had copied cells from another workbook ...

Show formula result in another sheet - microsoft.public.excel ...
sheet1 A:A contains a formula with some cells returning a value sheet2 A:A references sheet1 A:A with a simple formula: =sheet1!A1 above for...

Excel - How Do I Display Formula Results In Another Cell? - I am a ...
How Do I Display Formula Results In Another Cell? - I am a new ... in the cells rather than results. The remainder of the sheet shows the results rather than the formula.

Vba Code: Copy Rows To Another Sheet And Show All Related Result
Vba Code: Copy Rows To Another Sheet And Show All Related Result - hi ... if match found, then display result in Column D, on first tab, if no match display "-" The formula I ...

Show FORMULA or FORMAT of another cell - Welcome to the MVPs.org ...
... how to display the formula and formatting used in another ... get the formula used on another worksheet =GetFormula('sheet ... version formula has similar looking results ...

Excel Worksheet Shows Formulas, Not Results - AppScout
Recently, when I download a file from COGNOS into an Excel spreadsheet, I have trouble adding formulas. When I use the Function icon to enter a formula such as ...

7/18/2012 5:54:11 PM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by