Home

Excel 2016 how to autofill data entries based on a reference sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-762906%22%20slang%3D%22en-US%22%3EExcel%202016%20how%20to%20autofill%20data%20entries%20based%20on%20a%20reference%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762906%22%20slang%3D%22en-US%22%3E%3CP%3EI'd%20like%20to%20be%20able%20to%20create%20the%20setup%20of%20one%20sheet%20based%20on%20a%20reference%20sheet.%20For%20example%2C%20I%20have%20an%20assessment%20that%20has%20tasks%20with%20associated%20items.%20In%20the%20reference%20sheet%2C%20I%20would%20like%20the%20individual%20to%20input%20the%20number%20of%20tasks%2C%20the%20associated%20number%20of%20items%20with%20each%20task%2C%20and%20have%20these%20values%20create%20the%20correct%20number%20of%20columns%2Fheadings%20on%20the%20secondary%20sheet%20(Task%201%2C%20Task%201%20-%20Item%201%2C%20Task%201%20-%20Item%202%2C%20Task%202%2C%20etc.).%20It%20may%20be%20a%20matter%20of%20the%20reference%20sheet%20causing%20the%20secondary%20sheet%20to%20make%20certain%20columns%20visible%2Fhidden%2C%20but%20I'm%20not%20sure%20how%20to%20do%20this.%20I'd%20appreciate%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-762906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762940%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20how%20to%20autofill%20data%20entries%20based%20on%20a%20reference%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762940%22%20slang%3D%22en-US%22%3EYou%20may%20need%20VLOOKUP%20or%20INDEX-MATCH%2C%20depending%20on%20the%20layout%20of%20your%20data.%20Your%20sample%20would%20certainly%20clarify%20matters.%3C%2FLINGO-BODY%3E
Jgwmom
Occasional Visitor

I'd like to be able to create the setup of one sheet based on a reference sheet. For example, I have an assessment that has tasks with associated items. In the reference sheet, I would like the individual to input the number of tasks, the associated number of items with each task, and have these values create the correct number of columns/headings on the secondary sheet (Task 1, Task 1 - Item 1, Task 1 - Item 2, Task 2, etc.). It may be a matter of the reference sheet causing the secondary sheet to make certain columns visible/hidden, but I'm not sure how to do this. I'd appreciate any help.

1 Reply
Highlighted
You may need VLOOKUP or INDEX-MATCH, depending on the layout of your data. Your sample would certainly clarify matters.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies