T
Titanus
If anyone has a solution for this, I would be grateful!
In one spreadsheet I have two worksheets. Sheet 1 has a Column A
(Date: numbered sequentially, low to high), and the next three columns
(header A, B, C) contain closing stock prices for Stock A, Stock B,
Stock C. The data is NOT in sequential order (so B2 might be > B3 and
<<B4), but is paired to the DATE (column A) that price occurs. Far
across the spreadsheet, after a bunch of data work has been done on the
stock prices (we'll say Column AA) I am creating a buy or sell signal
for whatever stock matches my criteria; the value returned is the
header of the respective stock, so I know whether, on a certain date, I
should have bought A, B, or C. So in Column AA there may not be ANY
data until AA20, in which the return value might be A, and then maybe
the next cell down (AA21) is C, then back to A in AA22. Column AB is
the same thing, except these are SELL signals, with value returns of A,
B, or C.
On worksheet two I have Column A as the date (same as sheet 1) then the
three stock columns the same as sheet 1, each separated by an empty
column (so Stock A is column B, Stock B is column D, Stock C is column
F) . What I WANT to do is return to this sheet the markers from Sheet
1, column AA and AB. SO, let's say on Sheet1!AA20 = A, Sheet1!AA21 =
C, Sheet1!AA22 = B (in the To Buy column). On sheet 2 I want B20 = 2
(my signal for BUY), D22 = 2, and F21 = 2.
Again, it has to line up perfectly with Stock Name and Date. How do I
parse individual placings to another page? Oh, and there will always
be 1 and only 1 value to a cell on sheet 1.
Thanks for the help!
-Mr. T
In one spreadsheet I have two worksheets. Sheet 1 has a Column A
(Date: numbered sequentially, low to high), and the next three columns
(header A, B, C) contain closing stock prices for Stock A, Stock B,
Stock C. The data is NOT in sequential order (so B2 might be > B3 and
<<B4), but is paired to the DATE (column A) that price occurs. Far
across the spreadsheet, after a bunch of data work has been done on the
stock prices (we'll say Column AA) I am creating a buy or sell signal
for whatever stock matches my criteria; the value returned is the
header of the respective stock, so I know whether, on a certain date, I
should have bought A, B, or C. So in Column AA there may not be ANY
data until AA20, in which the return value might be A, and then maybe
the next cell down (AA21) is C, then back to A in AA22. Column AB is
the same thing, except these are SELL signals, with value returns of A,
B, or C.
On worksheet two I have Column A as the date (same as sheet 1) then the
three stock columns the same as sheet 1, each separated by an empty
column (so Stock A is column B, Stock B is column D, Stock C is column
F) . What I WANT to do is return to this sheet the markers from Sheet
1, column AA and AB. SO, let's say on Sheet1!AA20 = A, Sheet1!AA21 =
C, Sheet1!AA22 = B (in the To Buy column). On sheet 2 I want B20 = 2
(my signal for BUY), D22 = 2, and F21 = 2.
Again, it has to line up perfectly with Stock Name and Date. How do I
parse individual placings to another page? Oh, and there will always
be 1 and only 1 value to a cell on sheet 1.
Thanks for the help!
-Mr. T