i need to copy lots of links from other documents into one 'live' document. eg
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6
is the link in the formula bar. i need to drag the formula down so that the file number [01.xls] increases by on each time.
eg
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6
then
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[02.xls]Summary'!$D$6
then
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[03.xls]Summary'!$D$6
etc etc etc. is there a way to do this of shall i carry on with typing all teh file numebr sin??
cheers
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6
is the link in the formula bar. i need to drag the formula down so that the file number [01.xls] increases by on each time.
eg
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6
then
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[02.xls]Summary'!$D$6
then
='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[03.xls]Summary'!$D$6
etc etc etc. is there a way to do this of shall i carry on with typing all teh file numebr sin??
cheers