View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_3_] Stuart[_3_] is offline
external usenet poster
 
Posts: 50
Default automatic referencing in excel between two spreadsheets

How I get a cell to reference to another cell.

An example.

I have a balance sheet - One item in my worksheet "Balance Sheet" links
to another worksheet "Schedule 1" . What I want to happen is that next
to the cell in my balance sheet its shows a reference to the schedule
and in the schedule it shows a refernce to the balance sheet.

Does this make sense???

Hope you can help,

Kind Regards,

Stuart