| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a tracking log
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a tracking log
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 "Data Miner" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a tracking log
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 "Fred Smith" wrote: 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 "Data Miner" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a tracking log
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 "Data Miner" wrote in message ... 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 "Fred Smith" wrote: 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 "Data Miner" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I create a tracking log
Thanks. I will try the indirect function to see how it works but I solved the
problem by creating a Macro. "Fred Smith" wrote: 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 "Data Miner" wrote in message ... 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 "Fred Smith" wrote: 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 "Data Miner" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to create attendance tracking based on % and 2080 hours/year | Excel Discussion (Misc queries) | |||
| How do I create a payment tracking spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I create a spread sheet for tracking batting statistics? | New Users to Excel | |||
| How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
| How do you create a vendor tracking form for accounts payable pro. | Excel Discussion (Misc queries) | |||
Linear Mode
