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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies