Broken brain! Can you help?

Closed
Posts
1
Registration date
Monday May 26, 2014
Status
Member
Last seen
May 26, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hi guys,

As a relative newbie to excel I've been trying to solve a referencing problem for days and I'd be hugely grateful to anyone who can solve my headache!

I have an excel workbook with several tabs, each tab contains a list of students and multiple columns of corresponding data relating to their performance. The data comes from several independent reports which are generated separately, which I have exported and pasted into each of the tabs on my workbook.

I want to generate a new "combined" spreadsheet listing the students and referencing columns which I can pick and chose form several of the different reports on each tab.

I started by filtering them alphabetically, which would have made things really easy if every report had exactly the same number of students. The tricky part is that not all students feature on all the report lists, so I need to first look up and find them across all the tabs, and then populate my new spreadsheet with the corresponding data from columns I select.

It must be possible, I just don't know how! Can anyone help?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
guessing.
why not combine all the data in all the sheets in one master sheet ( a macro can be written for thlis) and then find unique student name by advanced filter and use autofilter looping through the unique student list.