Morning!
Try this one out (if even possible)
Tracking performance areas monthly/quarterly by person
Sheet ONE (Entire MONTH)
PAGE ONE= Week 1 (Each week is printed weekly)
Each Row has different person
Each column has different category tracker (#'s, %'s etc...)
Page TWO (Sheet one)
Same info, week 2...
Last page is MONTH 1 end totals. This was the easy part.
DO same for 2nd and 3rd sheet (Quarter)
Now I need to take the data from each person's WEEKLY data (row) for EACH week and have these in a separate QUARTER sheet (which shows week 1, week 2 etc..)by PERSON. I am able to cut/paste, circular reference each person, but this takes a LONG time.
Is there a way to have excel recognize I need (selected data) from JIM's week 1 data to show in column 1 of his quarterly file? And then do this for each person WITHOUT cut/paste? JIM is row 4, 49, 91, 140...Column data needed: H4, B4, C4, D4 etc...
Thanks in Advance!
Bookmarks