Ady Zavala
New Member
Good morning
I am trying to make some conditionals in my file.
As you can see in Columns A, D, G, J, M and P, there are named as 'HAB".
Columns B, E, H, K, N and Q, are named as "Statuses"
Columns C, F, I, L, O and R, are named as "Status"
In Column T, you can see numbers from 1 to 15.
Each number has a function, if I choose Number 1, it means OOO, "fuera de orden".
Number 2 means "OS", "Fuera de servicio"
And so on.
I need that if I put the number 1 I. Any cell from columns B, E, H, K, N and Q, the status on Columns C, F, I, L, O and R to change automatically according to what stands in Values in Column T.
Example as in the image I have attached.
Is it possible to be done?
And another thing, the workbook will change of name sheets everyday, so today will have a sheet called Julio 1, tomorrow will have a sheet called Julio 2 and so on. If it is done by code, would it affect if pages are added by day? Thank you so much in advance.
I am trying to make some conditionals in my file.
As you can see in Columns A, D, G, J, M and P, there are named as 'HAB".
Columns B, E, H, K, N and Q, are named as "Statuses"
Columns C, F, I, L, O and R, are named as "Status"
In Column T, you can see numbers from 1 to 15.
Each number has a function, if I choose Number 1, it means OOO, "fuera de orden".
Number 2 means "OS", "Fuera de servicio"
And so on.
I need that if I put the number 1 I. Any cell from columns B, E, H, K, N and Q, the status on Columns C, F, I, L, O and R to change automatically according to what stands in Values in Column T.
Example as in the image I have attached.
Is it possible to be done?
And another thing, the workbook will change of name sheets everyday, so today will have a sheet called Julio 1, tomorrow will have a sheet called Julio 2 and so on. If it is done by code, would it affect if pages are added by day? Thank you so much in advance.
