View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Circular references

I assume the hard part is to find the precedent cell on sheet1
once you are on sheet2.
Select the cell on sheet2 that you want to change.
Click on Trace Precedents on the Formula Auditing toobar.
Double click on the black arrow that points to the sheet1 icon.
When the Go To window appears,
double click the shown location.