How to fill over multiple pages in excel

Copper Contributor
Hello!

I am using excel for my scheduling. I have one schedule with all my employees name on one document with there area that they are working over nine weeks. I now need to make individual schedules that they can each receive. I have it so that excel pulls data from my master schedule and creates the persons individual schedule. But when I try to auto fill (basically I drag to create multiple individual ones but when I drag it does not do the next person on my list but it jumps to person 52 on my master list). Anyone have any suggestions?
1 Reply
Perhaps you need VLOOKUP or INDEX-MATCH, the arguments of which depend upon the structure of your data and the results you want to achieve.