View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ??

HI,

I HAVE TWO SHEETS (DIFFERENT BOOKS) WITH THE SAME INFORMATION. I USE ONE TO
ENTER THE DATA, AND THE OTHER ONE (ALON WITH OTHER SHEETS) IS THE ONE I USE
TO "SEE" THE DATA BUT NOT BEING ABLE TO ENTER OR AMEND ANY.

PEOPLE (WHO DO NOT ENTER THE DATA) NEED TO BE ABLE TO SEE THAT DATA, BUT I
DON'T WANT THEM MESSING AROUND WITH THE INFORMATION, SO I ENTER THE DATA
SOMEWHERE ELSE AND THE THRU FORMULAS I RECALL ALL THAT INFORMATION INTO THIS
OTHER SHEET WHERE YOU CAN ONLY CREATE LINKS... (AND ONLY IF YOU ARE A
SPECIFIC USER)

THE PROBLEM IS THAT I HAVE TO LINK SOME FILES TO THE PROTECTED SHEET FOR
PEOPLE TO DOWNLOAD, BUT IF I ALTER THE ORDER OF THE ORIGINAL DATA
(ALPHABETICALLY) IT CHANGES IN THE PROTECTED ONE BUT THE LINKS DON'T FOLLOW
BECAUSE THEY ARE ATTACHED TO A SPECIFIC CELL AND NOT RELATED TO THE FORMULA
IN THAT CELL...

IS THERE A WAY WHERE I CAN RECALL (=Hoja2!C3) LINKS FROM THE ORIGINAL SHEET
SO IF I CHANGE THE ORDER IT WILL BE REFLECTED IN THE PROTECTED ONE ALONG WITH
ANY FILES ATTACHED TO THE CELLS???

THANKS...