Need help traversing
I need help writing a code for traversing along a column in a specific order. Im not used to Excel and this is seeming very confusing. I would really appreciate any kind of help/suggestions/tips.
I have 4 specific columns that I'm gonna need. they are:
(They are all in different sheets)
Now there are multiple entries in each column and I need help traversing through them.
The column of "Saw5" will have an "X" marked in certain entries. Now what I need is to get the corresponding entries in the other columns for that specific product.
For example: If saw theres an "X" marked in the 3rd entry of "Saw5", what I need is to extract the values in the 3rd entry of "Pieces", "Phour" and "OEE".
Then check further and if saw theres an "X" marked in the 5rd entry of "Saw5", what I need is to extract the values in the 5rd entry of "Pieces", "Phour" and "OEE".
and so on...
So basically, I need to check for "X" in the "Saw5" and then find the corresponding values in the other columns and do certain calculations based on that...
If its required, the formula that Im going to use later is:
(If theres an "X")
then -> (Pieces / Phour) / (30 * 24 * OEE)
I will save this value in a new column created, it does not need to be in order...
Please help me out.