LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ Dany Excel Discussion (Misc queries) 5 April 16th 07 03:27 AM
Links Don't follow with copy [email protected] Excel Discussion (Misc queries) 1 September 22nd 06 10:37 PM
How do I pick the same cell in sheet 1!, Sheet2! and just drag Kim Excel Worksheet Functions 3 March 10th 06 12:00 AM
Cross sheet references (=Sheet2!B4) DejaVu Excel Discussion (Misc queries) 3 February 17th 06 04:33 PM
can I transfer data from sheet 1 to sheet2? deshall Excel Discussion (Misc queries) 2 December 8th 04 02:03 AM


All times are GMT +1. The time now is 02:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"