realitybend
07-10-2008, 11:10 AM
I have one workbook with a sheet named "Sheet1", and another workbook with a sheet named "Sheet2" In "Sheet1" I have a list of numbers in column A, such as 4, 3, 5, 6, 8, 9, 11, 10, etc. In "Sheet2" of the other workbook, there are corresponding numbers, also in column A. These, however, aren't nessecarily in order. In "Sheet2" in column AB there are numbers that correspond to the numbers in column A, e.g. The number in A57 would correspond to AB57.
I need to copy the number in column AB of "Sheet2" (which corresponds to the number in the same row of column A on "Sheet2" and also corresponds to some row in column A of "Sheet1") and I need to paste it into "Sheet1" column B next to the corresponding number in column A.
If that made sense to you, you're a genius, and I need your help. If you see any way I can clarify, please tell me.
Help! :help
I need to copy the number in column AB of "Sheet2" (which corresponds to the number in the same row of column A on "Sheet2" and also corresponds to some row in column A of "Sheet1") and I need to paste it into "Sheet1" column B next to the corresponding number in column A.
If that made sense to you, you're a genius, and I need your help. If you see any way I can clarify, please tell me.
Help! :help