Home

How to fill over multiple pages in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-634885%22%20slang%3D%22en-US%22%3EHow%20to%20fill%20over%20multiple%20pages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-634885%22%20slang%3D%22en-US%22%3EHello!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20using%20excel%20for%20my%20scheduling.%20I%20have%20one%20schedule%20with%20all%20my%20employees%20name%20on%20one%20document%20with%20there%20area%20that%20they%20are%20working%20over%20nine%20weeks.%20I%20now%20need%20to%20make%20individual%20schedules%20that%20they%20can%20each%20receive.%20I%20have%20it%20so%20that%20excel%20pulls%20data%20from%20my%20master%20schedule%20and%20creates%20the%20persons%20individual%20schedule.%20But%20when%20I%20try%20to%20auto%20fill%20(basically%20I%20drag%20to%20create%20multiple%20individual%20ones%20but%20when%20I%20drag%20it%20does%20not%20do%20the%20next%20person%20on%20my%20list%20but%20it%20jumps%20to%20person%2052%20on%20my%20master%20list).%20Anyone%20have%20any%20suggestions%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-634885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-635530%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20fill%20over%20multiple%20pages%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-635530%22%20slang%3D%22en-US%22%3EPerhaps%20you%20need%20VLOOKUP%20or%20INDEX-MATCH%2C%20the%20arguments%20of%20which%20depend%20upon%20the%20structure%20of%20your%20data%20and%20the%20results%20you%20want%20to%20achieve.%3C%2FLINGO-BODY%3E
Robert45
Occasional Visitor
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.