LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Back
Top