Posted to microsoft.public.excel.misc

Susan

external usenet poster

Posts: 271

Question about linking please

I can set a direct link to another workbook called

='[orange.xls]07-27'!$i$20

Is there a way to change it so that the 07-27 equals to whatever is entered
in cell a7, for example if 08-20 is entered it goes to workbook orange sheet
08-20

i tried

='[orange.xls]&a7'!$i$20, but that did not work

cam someone please help me

Thank you!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Linking /Formula Question	mark	Excel Discussion (Misc queries)	0	February 13th 07 09:50 PM
Linking and embedding question.	lumpjaw	Links and Linking in Excel	6	July 4th 06 06:05 PM
Linking question	Abnerz	Excel Discussion (Misc queries)	0	February 16th 06 08:52 PM
Linking Question	southpaw3229	Excel Discussion (Misc queries)	1	December 1st 05 08:40 PM
Another linking question	singlgl1	Excel Discussion (Misc queries)	3	October 27th 05 12:38 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us