Linking between files

A

aposatsk

I have two files. (1) One holds _current__training of our employees. (2
The second holds _future__training plans. The first (1) has tabs/sheet
for each employee. I would like it if everytime I typed a name in (2)
it would link to the appropriate sheet in (1). Is this possible?

Is it possible at all to create hyperlinks on one file which link t
another file's sheets
 
A

aposatsk

Please sir, can I have some more?

A simple "This is not possible" or "Yes this is possible, and here i
how..." would be great.

Thank you
 
D

Dave Peterson

It depends on how much you know, how important is it, or how much to you have to
spend.

Excel is much more Pull oriented than Push. You can use formulas to grab data
from other spots, but without using some sort of macros, pushing the data
somewhere else can't be done.

And lots of things can go wrong if you really want to push that data elsewhere.
You'll have to devise a method for updating just typos. An entry for Bob Smith
could have really been for Jim Smith. You'll have to make it so that Bob's
entry is deleted and the entry for Jim is added.

It can become very complex very quickly.

I like to keep my data in one location. Use another column for a future/done
indicator.

You can sort, filter, chart lots of stuff with the data in one location.

And if you really want to separate the data into various worksheets/workbooks,
....

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
A

aposatsk

Oh shoot!

I must have confused you by my wording.

What I meant to say is: I need to know how to make text in file (2) t
OPEN the specified tab in file (1). I did not mean that I need fil
(1) to change when I change file (2). I simply need a "hyperlink" t
redirect theuser to file (1)'s tabs when he clicks on a text in fil
(1)
 
A

aposatsk

I can't quite seem to get the correct formula. If the workbook that i
want to -redirect- to is called "Work1" and the sheet name is "Sheet2",
what would be the command for a hyperlink in another workbook to
redirect to Work1:Sheet2?
 
D

Dave Peterson

This worked to open book2.xls and go to A1 of sheet1:
=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me")
 
Top