Creating Links Between Spreadsheets

[vvll]

Is it possible to create links between spreadsheets based on
“if/then” criteria?

I have an invitation list for a party, and then an attendee list with
a whole different layout/fields for the invitees who respond
“yes”.

Can I create a link from “Invitee” to “RSVP”
list with “if RSVP = ‘yes’ then link to
“Attendee” list?

Any help appreciated

concaf2003

 

[David McRitchie]

Hi wII
Use the HYPERLINK Worksheet Function
Not clear on your question, this should get you started:

=IF(C2="RSVP",HYPERLINK("#RSVP!A1",RSVP!A1),IF(C2="invitee",HYPERLINK("#invitee!A1",invitee!A1),""))

--or--
=IF(C2="RSVP",HYPERLINK("#RSVP!A1","[link]"),IF(C2="invitee",HYPERLINK("#invitee!A1","[link]i"),""))

Please don't post with open and closed double quotes, they do
not come through very well. Just use the double-quote that
is on the keyboard for both.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm