Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing values in a table
Hi all!
I am asking your help to solve a problem. I have a general table consisted of 4 columns, and I want to change value in a cell in one column if a combination of another 2 cells in the same row is true. My table looks like that: A B C D Capacity Capacity fix Cycle_Num Step_Num 1 10 1 1 2 20 1 1 3 30 1 1 4 40 1 2 5 50 1 2 6 60 1 2 7 70 1 2 1 10 2 1 2 20 2 1 3 30 2 1 4 40 2 2 5 50 2 2 6 60 2 2 7 70 2 2 and my question is: is it possible to change all the 'Capacity' values with specific "Cycle_Num" and "Step_Num" indexes (for example Cycle_Num = 2 and Step_Num = 1 ) if the first 'Capacity' value in this range is for example higher then 2? Thanks in advance Eli |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing values in a table
RowCount = 2 Do while Range("A" & RowCount) < "" Capacity = Range("A" & RowCount) Cycle = Range("C" & RowCount) Step = Range("D" & RowCount) if Capacity 2 and Cycle = 2 and Step = 1 then 'Enter you code here End if RowCount = RowCount + 1 loop "אלי" wrote: Hi all! I am asking your help to solve a problem. I have a general table consisted of 4 columns, and I want to change value in a cell in one column if a combination of another 2 cells in the same row is true. My table looks like that: A B C D Capacity Capacity fix Cycle_Num Step_Num 1 10 1 1 2 20 1 1 3 30 1 1 4 40 1 2 5 50 1 2 6 60 1 2 7 70 1 2 1 10 2 1 2 20 2 1 3 30 2 1 4 40 2 2 5 50 2 2 6 60 2 2 7 70 2 2 and my question is: is it possible to change all the 'Capacity' values with specific "Cycle_Num" and "Step_Num" indexes (for example Cycle_Num = 2 and Step_Num = 1 ) if the first 'Capacity' value in this range is for example higher then 2? Thanks in advance Eli |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing values in a table
Many thanks
"Joel" wrote: RowCount = 2 Do while Range("A" & RowCount) < "" Capacity = Range("A" & RowCount) Cycle = Range("C" & RowCount) Step = Range("D" & RowCount) if Capacity 2 and Cycle = 2 and Step = 1 then 'Enter you code here End if RowCount = RowCount + 1 loop "אלי" wrote: Hi all! I am asking your help to solve a problem. I have a general table consisted of 4 columns, and I want to change value in a cell in one column if a combination of another 2 cells in the same row is true. My table looks like that: A B C D Capacity Capacity fix Cycle_Num Step_Num 1 10 1 1 2 20 1 1 3 30 1 1 4 40 1 2 5 50 1 2 6 60 1 2 7 70 1 2 1 10 2 1 2 20 2 1 3 30 2 1 4 40 2 2 5 50 2 2 6 60 2 2 7 70 2 2 and my question is: is it possible to change all the 'Capacity' values with specific "Cycle_Num" and "Step_Num" indexes (for example Cycle_Num = 2 and Step_Num = 1 ) if the first 'Capacity' value in this range is for example higher then 2? Thanks in advance Eli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing table cells colours using a master table | Excel Discussion (Misc queries) | |||
Filling in a table with changing range values | Excel Discussion (Misc queries) | |||
Pivot Table changing sum values using VB | Excel Programming | |||
Pivot Table - Changing Column Values | Excel Discussion (Misc queries) | |||
changing values in a Word Table | New Users to Excel |