How do i assign value to 3 cells =E41, =H41, = B41 by typing 41
 

How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks

How do i assign value to 3 cells =E41, =H41, = B41 by typing 41
 

You would need VBA code for that........are you up for that? If so, explain
what values you want put in those cells when you type 41 in your key cell,
and which cell is to be the key cell.......and any other conditions you can
think of........someone will help.....

Vaya con Dios,
Chuck, CABGx3


"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks

How do i assign value to 3 cells =E41, =H41, = B41 by typing 41
 

Are you looking to display the data that's in cell E41 into another cell?

Say E41 contains 100,
E42 - 200
E43 - 300


Say A1 contains:
=E41
And displays that 100.

Do you want to change what's in A1, depending on the "row value" in another
cell, say B1?
Where B1 = 42, then A1 will display 200?

If that's the case, then the formula in A1 could be:

=INDIRECT("E"&B1)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks

How do i assign value to 3 cells =E41, =H41, = B41 by typing 4
 

Thanks that helped

I also tried to use the Index() function and it did the job to
=INDEX(A1:H200,J2,2) Fills the Cell with data in B41 where J2 = 41

"Ragdyer" wrote:

Are you looking to display the data that's in cell E41 into another cell?

Say E41 contains 100,
E42 - 200
E43 - 300


Say A1 contains:
=E41
And displays that 100.

Do you want to change what's in A1, depending on the "row value" in another
cell, say B1?
Where B1 = 42, then A1 will display 200?

If that's the case, then the formula in A1 could be:

=INDIRECT("E"&B1)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in another
cell cell Named Row_No. The rumber number 41 will keep changing but the
column numbers are the same ie E, H and B please help

Thanks

How do i assign value to 3 cells =E41, =H41, = B41 by typing 4
 

So, how come you don't also make the column dependant on another cell, say
J3, where the formula becomes:

=INDEX(A1:H200,J2,J3)

Then you control column and row from reference cells outside the formula
itself.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Cells" wrote in message
...
Thanks that helped

I also tried to use the Index() function and it did the job to
=INDEX(A1:H200,J2,2) Fills the Cell with data in B41 where J2 = 41

"Ragdyer" wrote:

Are you looking to display the data that's in cell E41 into another
cell?

Say E41 contains 100,
E42 - 200
E43 - 300


Say A1 contains:
=E41
And displays that 100.

Do you want to change what's in A1, depending on the "row value" in
another
cell, say B1?
Where B1 = 42, then A1 will display 200?

If that's the case, then the formula in A1 could be:

=INDIRECT("E"&B1)


--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in
another
cell cell Named Row_No. The rumber number 41 will keep changing but
the
column numbers are the same ie E, H and B please help

Thanks

How do i assign value to 3 cells =E41, =H41, = B41 by typing 4
 

The Columns B E and H are constant ie Date, Rate and Value but the row keeps
changing depending on the number of entries. Thus the Values at the Summary
area can be changed by typing only the row number in J2.

Thnks
Govind

"Ragdyer" wrote:

So, how come you don't also make the column dependant on another cell, say
J3, where the formula becomes:

=INDEX(A1:H200,J2,J3)

Then you control column and row from reference cells outside the formula
itself.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Cells" wrote in message
...
Thanks that helped

I also tried to use the Index() function and it did the job to
=INDEX(A1:H200,J2,2) Fills the Cell with data in B41 where J2 = 41

"Ragdyer" wrote:

Are you looking to display the data that's in cell E41 into another
cell?

Say E41 contains 100,
E42 - 200
E43 - 300


Say A1 contains:
=E41
And displays that 100.

Do you want to change what's in A1, depending on the "row value" in
another
cell, say B1?
Where B1 = 42, then A1 will display 200?

If that's the case, then the formula in A1 could be:

=INDIRECT("E"&B1)


--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Cells" wrote in message
...
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41 in
another
cell cell Named Row_No. The rumber number 41 will keep changing but
the
column numbers are the same ie E, H and B please help

Thanks