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!
I would suggest reading Dave Pearson's post: http://www.microsoft.com/office/community/en-us/default.mspx?&query=linking+based+on+cell+value&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=72cb9b79-8e27-48b7-94fd-ec13d40e3a13&mid=b6727396-1510-4230-99ab-0d7d86137810 -- -SA "Susan" wrote: > 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!
