Hi
I have a spreadsheet with 2 worksheets.
Sheet1 holds a list of Names I.e. Mark, Paul, Peter etc
Sheet2 holds daily data, Column A = 1st day, Column B = 2nd day etc (this information changes month on month when new data is pasted in), it holds the name of the person and then below it holds a...