i need help with the attached sheet,i want to have data populated from sheet "Shifts" to Sheet " Working Schedule " based on the day starting from cell B2 in Sheet " Working Schedule " to be matching agent name and the day
Since your data is in such an awful arrangement on the Shifts sheet, the formula is a long one just to get the shift start to shift end times.
You must first give the range A1:X27 on the Shifts sheet a name myData (this shortens the formula(!)).
Then in cell B2 of the Working Schedule sheet you have this formula:
which you can copy down and across. Depending on your version of Excel, you may have to commit this formula to the sheet using Ctrl+Shift+Enter rather than the usual plain Enter. If you get an error in the cell, it's likely you need to do this.