Linking to another workbook

S

Susan

We have a workbook called LIST 2007.08 (for example), but every month for
auditors we save the workbook as LIST 06.30.08.

I have another workbook that has links to this workbook but the link needs
to change when we save it as 06.30.08, is there a way to have the link ask
the user which workbook to pull cell A1 from when they open the workbooks
with the links in it so it pull froms the new workbook 06.30.08?
 
R

RagDyeR

Have *both* WBs open when you save with the new name.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

We have a workbook called LIST 2007.08 (for example), but every month for
auditors we save the workbook as LIST 06.30.08.

I have another workbook that has links to this workbook but the link needs
to change when we save it as 06.30.08, is there a way to have the link ask
the user which workbook to pull cell A1 from when they open the workbooks
with the links in it so it pull froms the new workbook 06.30.08?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top