Hi, i would like to know how to Update some cells using data from another sheet on the same excel file.
I have made an example xls and attached it.
Basically each User 1(row) will have columns with the number of the days in a month.
When u assign the value "OK" i a cell that is in the column [example, day 21] then the column named User 1(on the other sheet)
will get the value "21" in its corresponding cell.
I think you are View attachment TEST.xlsxgoing to need to see the file attached
I have made an example xls and attached it.
Basically each User 1(row) will have columns with the number of the days in a month.
When u assign the value "OK" i a cell that is in the column [example, day 21] then the column named User 1(on the other sheet)
will get the value "21" in its corresponding cell.
I think you are View attachment TEST.xlsxgoing to need to see the file attached