Re: copy, paste and shift one down
I have been looking at your post for some time now and I am very indrigue with what you are trying to do. I have down loaded your file and it looks very good, but first of all I don't have the TPX_Index file so I just made one just to get rid of the #DIV/0 error. How are you getting the data into the TPX_Indes file.
I now have #DIV/0 errors in column "C" on the chart sheet. Is this a formula that get data for Sheet 1 or what.
I should would like to get this to work, I would like to be able to track another ticker.
Is there some way that you can give me some additional information on how the information in Column "C" is arrived.
Very good job sevan17 and all others that help put this together.