Hi guys,
Yes, day before Christmas but was on the computer anyway...BTW Merry Christmas to whomever answers later!
I have 50 worksheets, one each for a stock ticker. In Column E (with header) is the adjusted close prices.
I have written some code to consolidate each tickers adj. close price into one sheet called Adjusted Close Prices.
Everything works great, except when one of the individual sheets is for a continuous future ticker symbol (like CL=F). For some reason, this causes the aggregation to make a duplicate and the rest to be blank.
So, I'm thinking someone smarter than me on the matter might have a better suggestion to grab column E from each individual worksheet and place it consecutively in a column on a summary Adjusted Close Price sheet.
What I have...
ACP = Summary Sheet and the other 3 are continuous futures symbols.
In the CL=F sheet for example, here is the data...
I would like to take the Adj Close column from each individual worksheet <> "Adjusted Close Price" and copy it into the Adjusted Close Price sheet in the next column for each.
I can do this with stock symbols no problem, but when I use futures (with an equals = sign) it only puts the first one.
Example with only stocks...it works...er no it doesn't. I just noticed it makes a duplicate too...insert curse word!!
Example ACP sheet with only futures...it only works with the first one and then for some reason duplicates it (CL=F, CL=F)
I suspect it has something to do with my vlookup and I have messed with it long enough so I was hoping to start from scratch with a better way.
How can I easily get column E from each individual worksheet copied consecutively into a summary Adjusted Close Price sheet no matter what the name?
Thanks in advance!
Yes, day before Christmas but was on the computer anyway...BTW Merry Christmas to whomever answers later!
I have 50 worksheets, one each for a stock ticker. In Column E (with header) is the adjusted close prices.
I have written some code to consolidate each tickers adj. close price into one sheet called Adjusted Close Prices.
Everything works great, except when one of the individual sheets is for a continuous future ticker symbol (like CL=F). For some reason, this causes the aggregation to make a duplicate and the rest to be blank.
So, I'm thinking someone smarter than me on the matter might have a better suggestion to grab column E from each individual worksheet and place it consecutively in a column on a summary Adjusted Close Price sheet.
What I have...
ACP = Summary Sheet and the other 3 are continuous futures symbols.
In the CL=F sheet for example, here is the data...
I would like to take the Adj Close column from each individual worksheet <> "Adjusted Close Price" and copy it into the Adjusted Close Price sheet in the next column for each.
I can do this with stock symbols no problem, but when I use futures (with an equals = sign) it only puts the first one.
Example with only stocks...it works...er no it doesn't. I just noticed it makes a duplicate too...insert curse word!!
Example ACP sheet with only futures...it only works with the first one and then for some reason duplicates it (CL=F, CL=F)
I suspect it has something to do with my vlookup and I have messed with it long enough so I was hoping to start from scratch with a better way.
How can I easily get column E from each individual worksheet copied consecutively into a summary Adjusted Close Price sheet no matter what the name?
Thanks in advance!