Writing a list to a new worksheet based on a conditional on a different worksheet

[freelance]

I need to write data to a worksheet based on a conditional (If) on a different worksheet.

Column A of Worksheet1 has codenames of students; B has their scores (0-100). On Worksheet2, I want to create a list of only those students that got a score >90).

What would I do differently if Worksheet3 had a mapping of codenames (in column A) to first and last names (in columns B & C). This time, the requirement is to write on Worksheet2 the codenames, followed by the first and last names only of students that have score>90.

[oeldere]

It can be done, but it's easier to show you, if you add an excel file, without confidentional information.

Please also add the desired (expected) result.

[freelance]

StudentData.xlsxThanks Oeldere. Attached is a sanitized and simplified xls. The input is all done on the InputSheet. Coded score is manually updated by the teacher. Report is auto generated each time a score is changed. Report is the expected result. I was thinking of adding VBA button that the teacher clicks to generate the report?

[oeldere]

Why not just filter on column C in the input sheet.

See the attached file.

I wasn't able to attache the file (for forum issue reason.

[freelance]

So what happens if there are no 10's in the list at the beginning of the quarter. Then 10's get added later? Would I have to recreate the pivot table each time? Or could the table self populate with the 10's once they started showing up? I like the idea of using the pivot table. Also, is there a way of having a pivot table pivot around multiple worksheets? I know there is a create relationship method where tables relate to each other, but that requires unique fields, so not sure how that would work if there were multiple classes in different worksheets that all had to be pulled together into a single report.

[oeldere]

for your first question

make an table of it (before making an pivot table)

Excel 2007 => insert => table.

Then the new added datta will automatic be in the table (unless you have gaps (empty rows) in your data).

Then you could refresh the data.

Excel 2007 => data => refresh.

If you have multiple sheets, I suggest you pull all data together and after that make an pivot table of it.