D
Dream
Hi all,
I appreciate your help on the following. Please refer to teh example at the
bottom.
in the first sheet i have the following,
A 1 20
B 3 30 60
C 5 10 20
in the second sheet i have,
1 2 3 4 5 6 7 8 9
i want excel to distribute the information above into the second sheet, so
that the result will be in sheet 2 to be as
1 2 3 4 5 6 7 8
9
project A 20
project B 30 60
project C 10 20
please note that the idea is that for each project in sheet1, copy the
entire row to sheet2 starting from the location where the numbers in the
second column match the numbers in sheet2.
For example, for project A, the number is 1, so copy the entire row (in this
case 20) to the location under 1 in sheet2.
for project B, go to coloumn 3 in sheet 2, and copy the entire row (in this
case 2 cells 30 and 60) into adjacent cells in sheet2 starting at column 3,
so that 30 will reside in column3, and 60 will reside in the column next to
it which is column 4...and so forth...
Thanks in advance
I appreciate your help on the following. Please refer to teh example at the
bottom.
in the first sheet i have the following,
A 1 20
B 3 30 60
C 5 10 20
in the second sheet i have,
1 2 3 4 5 6 7 8 9
i want excel to distribute the information above into the second sheet, so
that the result will be in sheet 2 to be as
1 2 3 4 5 6 7 8
9
project A 20
project B 30 60
project C 10 20
please note that the idea is that for each project in sheet1, copy the
entire row to sheet2 starting from the location where the numbers in the
second column match the numbers in sheet2.
For example, for project A, the number is 1, so copy the entire row (in this
case 20) to the location under 1 in sheet2.
for project B, go to coloumn 3 in sheet 2, and copy the entire row (in this
case 2 cells 30 and 60) into adjacent cells in sheet2 starting at column 3,
so that 30 will reside in column3, and 60 will reside in the column next to
it which is column 4...and so forth...
Thanks in advance