G
Guest
My experience with Excel is very limited. I want to be able to use an Excel
spreadsheet to make various selections. For instance column B is used as the
selection cell, equations are in column C. If I put the selection number in
column B, I want the selected equation to be put in a different column.
For example
Cells A1 to A40 are numbered 1 to 40.
Cells C1 to C40 each contain an equation.
I want to use Cells B1 to B40 to type in the selection number.
For instance, I want to select the equations in C5, C11, C20, C33 and C38.
So for my selections I type number 1 in B5
number 2 in B11
number 3 in B20
number 4 in B33
number 5 in B38
The equations in C5, C11, C20, C33 and C38 are put in the selected order
into a column M1, M2, M3, M4, M5 and M6 on the same or another worksheet.
For example:
A B C
1 1 A+B+C
2 2 2A+2B+2D
3 3 4y+4x+3w+4y+4x
4 4 4y+4x+3w+4y
5 5 1 y+4x+7w
6 6 4y+10x+3w
7 7 4y+3x+3w
8 8 11y+4x+3w
9 9 9y+4x+3w
10 10 4y+4x+14w
11 11 2 y+7x+3w
Any help gratefully accepted.
spreadsheet to make various selections. For instance column B is used as the
selection cell, equations are in column C. If I put the selection number in
column B, I want the selected equation to be put in a different column.
For example
Cells A1 to A40 are numbered 1 to 40.
Cells C1 to C40 each contain an equation.
I want to use Cells B1 to B40 to type in the selection number.
For instance, I want to select the equations in C5, C11, C20, C33 and C38.
So for my selections I type number 1 in B5
number 2 in B11
number 3 in B20
number 4 in B33
number 5 in B38
The equations in C5, C11, C20, C33 and C38 are put in the selected order
into a column M1, M2, M3, M4, M5 and M6 on the same or another worksheet.
For example:
A B C
1 1 A+B+C
2 2 2A+2B+2D
3 3 4y+4x+3w+4y+4x
4 4 4y+4x+3w+4y
5 5 1 y+4x+7w
6 6 4y+10x+3w
7 7 4y+3x+3w
8 8 11y+4x+3w
9 9 9y+4x+3w
10 10 4y+4x+14w
11 11 2 y+7x+3w
Any help gratefully accepted.