Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LINKS TO FOLLOW FROM ONE SHEET (=SHEET2!C3) TO ANOTHER ??
Please don't SHOUT.
-- David Biddulph "John" wrote in message ... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
Links Don't follow with copy | Excel Discussion (Misc queries) | |||
How do I pick the same cell in sheet 1!, Sheet2! and just drag | Excel Worksheet Functions | |||
Cross sheet references (=Sheet2!B4) | Excel Discussion (Misc queries) | |||
can I transfer data from sheet 1 to sheet2? | Excel Discussion (Misc queries) |