Entering Data from another sheet

Copper Contributor

Hello , 

I am creating a new excel sheet from scratch as my old program FileMaker Pro isn't compatible anymore. I used to be able to have a template on there, and it would pull data for each student individually from another source. 
I need to somehow recreate this in excel, and pull data into my template that includes students names, DOB, and classroom name. 

Is it possible to set this up so data for each student pulls into my template and as I scroll it switches to a different student and their info? 

 

 I currently have all my data pulled.

Does the data all need to be on one line combined in one cell or can everything have its own cell then pull into the template into a certain cell for each student? So essentially it all pulls together and as I scroll it switches students and their info.

thanks so much. I know this is a big ask! 

1 Reply
Re:So essentially it all pulls together and as I scroll it switches students and their info.

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-create-review-forms-in-excel/d1474ce...