Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, highlight cells in which you are typing, for visability. | Excel Discussion (Misc queries) | |||
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN. | Excel Discussion (Misc queries) | |||
Quickly typing dates into cells | Excel Discussion (Misc queries) | |||
I need help getting Excel to auto-fill cells when I begin typing . | New Users to Excel | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |