I have two files. (1) One holds _current__training of our employees. (2)
The second holds _future__training plans. The first (1) has tabs/sheets
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 to
another file's sheets?


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

Please sir, can I have some more?

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

Thank you!


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

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

aposatsk wrote:

Please sir, can I have some more?

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

Thank you!

--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

--

Dave Peterson

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) to
OPEN the specified tab in file (1). I did not mean that I need file
(1) to change when I change file (2). I simply need a "hyperlink" to
redirect theuser to file (1)'s tabs when he clicks on a text in file
(1).


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

Take a look at Insert|Link
or the =hyperlink() worksheet function.

aposatsk wrote:

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) to
OPEN the specified tab in file (1). I did not mean that I need file
(1) to change when I change file (2). I simply need a "hyperlink" to
redirect theuser to file (1)'s tabs when he clicks on a text in file
(1).

--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

--

Dave Peterson

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?

Dave Peterson Wrote:
Take a look at Insert|Link
or the =hyperlink() worksheet function.

Dave Peterson


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

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



aposatsk wrote:

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?

Dave Peterson Wrote:
Take a look at Insert|Link
or the =hyperlink() worksheet function.

Dave Peterson

--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=567626

--

Dave Peterson