I have two worksheets.
Worksheet #1, row one, contains cells that have an "x" manually entered, but where the "x" is entered can vary. It can be anywhere in that row - A1, D1, T1, etc. However, all cells to the right of this first "x" will contain an "x" as well, i.e., no blank cells to the right.
On the second row of worksheet #1 it needs to pull the value of cell A1, worksheet #2, and put it in the same column as the first "x". So regardless of where the "x" is located in worksheet #1, row #1, whether it happens in column A,D,G etc the value beneath it should be cell A1 from worksheet #2. To the right of this pulled value should be the adjacent cell value from worksheet #2, i.e., in this case the value in cell A2, and so on.
I don't have file to upload because I don't how to even start figuring this out. Anyone have a suggestions?
Chris
Worksheet #1, row one, contains cells that have an "x" manually entered, but where the "x" is entered can vary. It can be anywhere in that row - A1, D1, T1, etc. However, all cells to the right of this first "x" will contain an "x" as well, i.e., no blank cells to the right.
On the second row of worksheet #1 it needs to pull the value of cell A1, worksheet #2, and put it in the same column as the first "x". So regardless of where the "x" is located in worksheet #1, row #1, whether it happens in column A,D,G etc the value beneath it should be cell A1 from worksheet #2. To the right of this pulled value should be the adjacent cell value from worksheet #2, i.e., in this case the value in cell A2, and so on.
I don't have file to upload because I don't how to even start figuring this out. Anyone have a suggestions?
Chris
