View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gotroots Gotroots is offline
external usenet poster
 
Posts: 114
Default Show formula result in another sheet

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?