Need Help generating a and copying a chain of code.

[borderpc]

Ok. So I created a formula to genterate from one program to the other. I am use to being able to click at drag the formula and have it create a new one such as 1,2,3,4,5. This formula is a little more complex and does not do that. Please help. Here is the formula.

='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6

When I highlight and drag them I want it to create 121113,121213, and so on. It just keeps creating

='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6

Please help. What can I do?

[Pepe Le Mokko]

Hi

please first adapt your title per forum rules - Thx

[borderpc]

Thanks for the help

[Pepe Le Mokko]

If you start in row 1 try ="'C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]12"&text(row()+8,"00")&"13'!$N$6" and drag down as needed.

This will only work for December 2013.Do you want it to go through to 010114 etc..

EDIT if so try ="'C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]"&TEXT(DATEVALUE("08/12/2013")+ROW(),"mmddyy")&"'!$N$6"

[shg]

	A	B	C
1	Start date	12/09/2013
2	File & sheet	C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]
3	Cell	N6
4		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!N6	B4: ="='" & $B$2 & TEXT(B$1+ROWS(B$4:B4)-1, "mmddyy") &"'!" & B$3
5		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!N6
6		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121113'!N6
7		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121213'!N6
8		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121313'!N6
9		='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121413'!N6

The results are just text, though. Then you can copy B4:B9, paste as values, then find and replace = with =