How do I create a tracking log

[Data Miner]

I am trying to create a tracking log for our ECO process. I have created a
template and a tracking log in EXCEL. The Tracking Log references cells from
the template.

Here is an example. Column A references the ECO number the formular is
='[ECO 1234.xls]Sheet 1'!$C$4. Is there a way to make this number
sequentally down the column without having to do it manually?

 

[Fred Smith]

Yes, take out the dollar signs. '$C$4' means 'don't change this reference ever'.
'C4' means 'adjust the reference when I copy'. So when you copy down, it will
change to D4, E4, etc.

 

[Data Miner]

I didn't explain it properly. The Cell reference $C$4 I don't want the
change. I want to change the '[ECO 1234.xls] sequentally down the column so
it reads
'[ECO 1234.xls]
'[ECO 1235.xls]
'[ECO 1236.xls]

Thanks for the response

Yes, take out the dollar signs. '$C$4' means 'don't change this reference ever'.
'C4' means 'adjust the reference when I copy'. So when you copy down, it will
change to D4, E4, etc.

--
Regards,
Fred

I am trying to create a tracking log for our ECO process. I have created a
template and a tracking log in EXCEL. The Tracking Log references cells from
the template.

Here is an example. Column A references the ECO number the formular is
='[ECO 1234.xls]Sheet 1'!$C$4. Is there a way to make this number
sequentally down the column without having to do it manually?

 

[Fred Smith]

You can start with the Indirect function.

If A5 = '[ECO 1234.xls]Sheet 1'!$C$4

then =indirect(a5) is the same as ='[ECO 1234.xls]Sheet 1'!$C$4

Now, hopefully, you can create a formula which will create your file name as
it's copied down. Something like:

="'[ECO 12"&Row(a34)&".xls]Sheet 1'!$C$4"

--
Regards,
Fred

I didn't explain it properly. The Cell reference $C$4 I don't want the
change. I want to change the '[ECO 1234.xls] sequentally down the column so
it reads
'[ECO 1234.xls]
'[ECO 1235.xls]
'[ECO 1236.xls]

Thanks for the response

Yes, take out the dollar signs. '$C$4' means 'don't change this reference
ever'.
'C4' means 'adjust the reference when I copy'. So when you copy down, it will
change to D4, E4, etc.

--
Regards,
Fred

I am trying to create a tracking log for our ECO process. I have created a
template and a tracking log in EXCEL. The Tracking Log references cells
from
the template.

Here is an example. Column A references the ECO number the formular is
='[ECO 1234.xls]Sheet 1'!$C$4. Is there a way to make this number
sequentally down the column without having to do it manually?

 

[Data Miner]

Thanks. I will try the indirect function to see how it works but I solved the
problem by creating a Macro.

You can start with the Indirect function.

If A5 = '[ECO 1234.xls]Sheet 1'!$C$4

then =indirect(a5) is the same as ='[ECO 1234.xls]Sheet 1'!$C$4

Now, hopefully, you can create a formula which will create your file name as
it's copied down. Something like:

="'[ECO 12"&Row(a34)&".xls]Sheet 1'!$C$4"

--
Regards,
Fred

I didn't explain it properly. The Cell reference $C$4 I don't want the
change. I want to change the '[ECO 1234.xls] sequentally down the column so
it reads
'[ECO 1234.xls]
'[ECO 1235.xls]
'[ECO 1236.xls]

Thanks for the response

Yes, take out the dollar signs. '$C$4' means 'don't change this reference
ever'.
'C4' means 'adjust the reference when I copy'. So when you copy down, it will
change to D4, E4, etc.

--
Regards,
Fred


I am trying to create a tracking log for our ECO process. I have created a
template and a tracking log in EXCEL. The Tracking Log references cells
from
the template.

Here is an example. Column A references the ECO number the formular is
='[ECO 1234.xls]Sheet 1'!$C$4. Is there a way to make this number
sequentally down the column without having to do it manually?