Book2.xlsx (10.3 KB)
I have Excel Sheet with Sheet 1, 2, 3
Sheet 1: Name, Student, Class.
Sheet2: Name, English, Social, Maths…(Marks in Subject)
Sheet 3: Name, English, Maths.
How can go each row of name in Sheet1 and pass that to Sheet2 and get english and maths marks and paste it to Sheet 3 ?