Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Extract (only non blank cell + highest value) data from multiple similiar tabs


Hi guys...Please help me with my workbook (attached)

In the workbook there are four tabs i.e. Cumulative, Data1, Data2, Data3. Tabs Data1, Data2, and Data3 contain information of student performance in each semester.

My question is, how to extract automatically information from Data1, Data2, and Data3 and put it all on Cumulative with these two additional condition:

  • I only want to extract all non BLANK cell of B5:C9 from each Data1, Data2, and Data3
  • If there are subject that retaken, I want to extract data with the highest grade. (as you can see in Data1, Data2, and Data3 there is one subject that always appeared i.e. Biology, this subject was retaken twice with highest grade is B).

I am sorry from my bad english, i hope you can understand my question. Thank you so much!


Answer the Question

You must create an account to use the forum. Create an Account or Login