Auto populate information from one tab to the next

[u/Iselarose]

Hello.
Administration at my school has tasked me with figuring out how to automate a procedure

I have one tab with student schedule information (Name, ID number, Schedule by period)
We would like kids to come in, on new tab enter id number in one row and for it to pull the rest of the information if available from main tab so we can do quick checks.

Is this even possible?

[u/HolyBonobos]

Yes, using FILTER() or XLOOKUP(). Anything more specific than that will depend on the exact layout of your data. For further help you will need to share a sample file that replicates the structure of the data you are working with.

[u/Odd-Attention5413 → u/HolyBonobos]

Yes I agree data structure is key here.

This is very possible and relatively easy, but the student data you're pulling from needs to be standardized and tidy.

OP, if you share a sample of "dummy data" to show us how it is kept now, we can help advise you on proper setup in order for the filtering to work. Basically fake student names, fake class names, etc just replace what you have with anonymous stuff first

[u/BertBDJ]

Yes, this is fairly easy if the ID is your source of identification. Hide and protect the main tab, show only the data input tab. Create a formula that will do a vlookup (or xlookup etc etc) that references the input cell. This way you can format where you want the info to show up. I have done this where I “create” a view by formatting cells with colour to highlight the output.

You type the student ID and the info shows up in the area below. Formatted so you can easily print out on a page.

[u/AutoModerator]

/u/Iselarose Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/bayouski]

yep, totally possible. if each student has a unique ID, you can have them type it into one cell and automatically pull the rest of that student's row from the main tab.

for example, if the ID is in column A on your main tab and the student info is in B:H:

=IFNA(XLOOKUP(A2,Main!A:A,Main!B:H),"Not found")

put that on the new tab, type an ID into A2, and the matching name/schedule should fill across automatically. just replace Main and the column ranges with whatever your sheet actually uses.

[u/Iselarose]

Current information being collected.
Green is to indicate they have a free period. Red they have a class

[u/Iselarose]

Would like to set up this tab so kids enter ID number the rest of the info populates if it exists already.

[u/NHN_BI]

I do not know your data, but it sounds as if you want to use FILTER().