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
|