Links To Follow From One Sheet (=sheet2!c3) To Another ??

[Pep2535]

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

 

[shades]

I might consider some kind of response, but please, do not write using ALL CAPITAL LETTERS. It is very annoying and difficult to read, and red on top.

Thanks
________
VAPORIZER REVIEWS

 

[Pep2535]

Thanks. I could use a lot of help... I can't get it working (or work my way around).