adding a cell and linking to other sheets (2000/2003)

Topic

New Reply

I have a spreadsheet that has multiple sheets. These sheets have some linking in them. I need to add a link in one spreadsheet, but this link also needs to be added to a few other sheets. Is there a easy way to have it do this. For example, Sheet1 I will be inserting a row and putting information in say cell C2. I also need to link this cell to Sheet 2,4,5,etc. Is there a way I can do this other than to go to each sheet and do it.

Reply | Quote

Replies

Select all of the sheets by holding down Ctrl and clicking on the sheet tabs. Create the link on one of the sheets and it should be created in all of them.

Reply | Quote

Thanks.

Reply | Quote