1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Student report template exclude column if nothing has been selected in the column

Our take

Creating student reports can be a streamlined process with the right template, allowing for personalized insights into each student's performance. In your case, you're seeking a solution to exclude columns that lack selections while still maintaining lead-in clauses for specific skills. For instance, if no input is selected for reading, you want to retain the statement, "(Name)'s reading skills are ______," without cluttering the report.

I have managed to find a template to generate student reports and have been editing it. It allows me to input the student's name, pronouns, and write a lead in clauses like, "In regards to writing" etc before a statement that the teacher will choose for their student reports.

I haven't completed writing in all the choices for the inputs. I have run into an issue because there are colums I'd like to skip when no selection has been made (even if there is a short comment there).

Ex:

Headers for each section and drop down menu. Each skill is followed up with a comment. The concerns are quiet student, disruptive student, and easily distracted student.

Is there any way to skip the column if I haven't selected anything and there is short clause already written? Ex: I don't want to select anything for reading, but the lead in for reading is "(Name)'s reading skills are ______".

submitted by /u/sodapop-popcorn
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#student report template#input#drop down menu#lead in clauses#skills#writing skills#student's name#selection#section headers#pronouns#column#input choices#report generation