OK here's what I'm trying to do.
I have a score sheet that is updated on a daily basis. Each column (A,B,C,D,etc) on that sheet is for a different person. Each row (1,2,3,4,etc.) is a different subject.
Then each person has their own sheet to track their scores over time. Columns are day 1, day 2, etc, Rows again the subject.
It's easy enough to copy and paste them each day from the daily sheet to the persons individual sheet.
However I'm looking for a way to have it auto update and was wondering if there was a way to compare the dates in the cells to do this.
Such as on the persons sheet if day 1 equals the same date as on the score sheet then copy those cells over from the master sheet to the persons sheet on day 1.
I know there are macro's and such to do this but I am limited to what I can do on work computers I pretty much have to stick to formulas no matter how tedious it is.
I didn't make the original sheets and I'm still learning excel by trial and error. The individuals persons sheets auto-populate with dates in each column once a starting date is entered in a cell at the top of the sheet.
I do however have permission to pretty much do what I want with the sheets when it comes to this even if I have to do a rehaul of the entire thing.
If it's easier to just copy and paste let me know.
Bookmarks