code to get students marks from source sheet to destination sheet.

[rzml]

hi,
I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I am hoping that it would be vlookup with an input box (since the evaluation type and student will change).

Thanks

 

[Saurabhj]

Hi rzml,

Kindly share the sheet having data.

Thanks,
Saurabh

 

[rzml]

Hi rzml,

Kindly share the sheet having data.

Thanks,
Saurabh

ID	section	Quiz (10%)	Mid (20%)	Assi (10%)
201420031	61​	7.3	12	8.4
201510186	61​	7.3	13	8.5
201510526	61​	5.2	7	8.5
201610299	61​	4.6	9	8.5
201611256	61​	7.5	11	8.9
201720041	61​	9.6	17	9.9
201720044	61​	7.2	15	8.5
201720048	61​	6.6	7	0
201720343	61​	6.1	12	7.2
201810012	61​	6.4	11	10
201810028	61​	10.0	19	10
201810032	61​	7.7	6	9.6
201810042	61​	7.0	10	7.9
201810108	61​	10.0	19	10
201810118	61​	7.5	12	7.9
201810154	61​	8.0	13	8.8
201810190	61​	9.6	20	10
201810232	61​	8.0	15	10
201810240	61​	8.8	19	9.6
201810262	61​	7.6	15	9.6
201810271	61​	7.6	11	10
201810305	61​	8.0	13	9.5
201810374	61​	5.7	10	10
201810526	61​	7.6	16	9.6
201810560	61​	6.8	15	8.8
201810619	61​	7.5	14	8.6
201810637	61​	7.1	16	10
201810757	61​	8.0	7	8.8
201810761	61​	5.2	7	7.2
201810863	61​	7.3	13	8.6
201210441	62​	0.0	0	0
201210997	62​	6.4	17	9.9
201610115	62​	5.2	10	8.9
201620564	62​	6.0	10	8.5
201710022	62​	6.6	13	7.4
201710074	62​	6.8	16	7.4
201710088	62​	5.5	8	8.5
201810087	62​	10.0	17	9.5
201810090	62​	5.7	10	8.5
201810180	62​	4.3	7	9.9
201810312	62​	8.0	12	9.6
201820383	62​	6.1	13	9.6
201820477	62​	6.0	13	7.8
201911208	62​	8.4	14	10

I apologise don't know how to share the sheet

 

[rzml]

ID	section	Quiz (10%)	Mid (20%)
201420031	61
201510186	61
201510526	61
201610299	61
201611256	61
201720041	61
201720044	61
201720048	61
201720343	61
201810012	61
201810028	61
201810032	61
201810042	61
201810108	61
201810118	61
201810154	61
201810190	61
201810232	61
201810240	61
201810262	61
201810271	61
201810305	61
201810374	61
201810526	61
201810560	61
201810619	61
201810637	61
201810757	61
201810761	61
201810863	61
201210441	62
201210997	62
201610115	62
201620564	62
201710022	62
201710074	62
201710088	62
201810087	62
201810090	62
201810180	62
201810312	62
201820383	62
201820477	62
201911208	62

 

[maabadi]

Are you want to input student ID at Input Box and then VBA or Vlookup return other data based it
For Vlookup:

=VLOOKUP(A2,Sheet1!$A$1:$E$25,2,FALSE)

Change Sheet1!$A$1:$E$25 to your Source Range Address at sheet1
Change 2 to column of result you want for each column

 

[maabadi]

You can Use XL2BB ADDIN for sharing. I think it is better to you write All of your ID that you need result for them At Column A and then Run Macro Once. Otherwise for Each Input ID you should Macro One Time to Get ID from InputBox.

 

[rzml]

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	ID	section	Quiz (10%)	Mid (20%)	Assi (10%)	Lab (14%)	Tut (6%)	Total 40%	Total 60%	Final E40%	Total
2	201420031	61	7.3	12	8.4	13	5	33.67	46	28	73
3	201510186	61	7.3	13	8.5	12.5	4.5	32.77	45	29	75
4	201510526	61	5.2	7	8.5	8	5	26.7	34	23	56
5	201610299	61	4.6	9	8.5	12.5	4	29.56	39	17	56
6	201611256	61	7.5	11	8.9	7	5	28.4	40	18	58
7	201720041	61	9.6	17	9.9	13	6	38.5	55	36	91
8	201720044	61	7.2	15	8.5	13	5.5	34.2	50	26	76
9	201720048	61	6.6	7	0	12.5	4.5	23.6	31	17	48
10	201720343	61	6.1	12	7.2	9.5	6	28.84	41	26	67
11	201810012	61	6.4	11	10	12.5	4.5	33.4	44	27	71
12	201810028	61	10.0	19	10	13	6	39	58	39	97
13	201810032	61	7.7	6	9.6	13	5	35.33	42	21	63
14	201810042	61	7.0	10	7.9	10.5	4	29.36	40	22	62
15	201810108	61	10.0	19	10	12.5	6	38.5	57	37	94
16	201810118	61	7.5	12	7.9	8	4.5	27.9	40	29	69
17	201810154	61	8.0	13	8.8	12.5	5.5	34.8	48	30	78
18	201810190	61	9.6	20	10	13	6	38.6	58	40	98
19	201810232	61	8.0	15	10	13	5	36	51	35	86
20	201810240	61	8.8	19	9.6	13	6	37.4	57	37	94
21	201810262	61	7.6	15	9.6	13	5	35.2	50	29	79
22	201810271	61	7.6	11	10	11.5	4.5	33.6	45	32	76
23	201810305	61	8.0	13	9.5	9	4	30.5	44	33	76
24	201810374	61	5.7	10	10	13	4.5	33.18	43	24	67
25	201810526	61	7.6	16	9.6	13	5.5	35.7	52	31	83
26	201810560	61	6.8	15	8.8	13	5.5	34.1	49	32	81
27	201810619	61	7.5	14	8.6	12.5	5	33.6	48	31	79
28	201810637	61	7.1	16	10	13	5	35.05	51	32	83
29	201810757	61	8.0	7	8.8	12.5	6	35.25	42	26	68
30	201810761	61	5.2	7	7.2	9	4	25.43	32	22	54
31	201810863	61	7.3	13	8.6	13	4.5	33.37	46	28	74
32	201210441	62	0.0	0	0	0	0	0	0	0	0
33	201210997	62	6.4	17	9.9	9	6	31.3	48	33	82
34	201610115	62	5.2	10	8.9	12.5	4	30.63	40	23	63
35	201620564	62	6.0	10	8.5	3	4	21.5	31	17	49
36	201710022	62	6.6	13	7.4	10.5	4.5	28.96	42	17	59
37	201710074	62	6.8	16	7.4	13	5	32.2	48	26	74
38	201710088	62	5.5	8	8.5	10.5	4.5	28.95	37	21	58
39	201810087	62	10.0	17	9.5	14	6	39.5	57	36	93
40	201810090	62	5.7	10	8.5	11.5	4.5	30.18	40	19	59
41	201810180	62	4.3	7	9.9	14	4.5	32.72	40	20	60
42	201810312	62	8.0	12	9.6	13	5	35.6	48	34	82
43	201820383	62	6.1	13	9.6	13	5.5	34.24	47	27	74
44	201820477	62	6.0	13	7.8	0	0	13.8	27	20	47
45	201911208	62	8.4	14	10	13	6	37.4	52	31	82
Sheet1

this is the source

Book1.xlsx
	A	B	C	D
1	ID	section	Quiz (10%)	Mid (20%)
2	201420031	61
3	201510186	61
4	201510526	61
5	201610299	61
6	201611256	61
7	201720041	61
8	201720044	61
9	201720048	61
10	201720343	61
11	201810012	61
12	201810028	61
13	201810032	61
14	201810042	61
15	201810108	61
16	201810118	61
17	201810154	61
18	201810190	61
19	201810232	61
20	201810240	61
21	201810262	61
22	201810271	61
23	201810305	61
24	201810374	61
25	201810526	61
26	201810560	61
27	201810619	61
28	201810637	61
29	201810757	61
30	201810761	61
31	201810863	61
32	201210441	62
33	201210997	62
34	201610115	62
35	201620564	62
36	201710022	62
37	201710074	62
38	201710088	62
39	201810087	62
40	201810090	62
41	201810180	62
42	201810312	62
43	201820383	62
44	201820477	62
45	201911208	62
Sheet2

this is the destination

 

[rzml]

You can Use XL2BB ADDIN for sharing. I think it is better to you write All of your ID that you need result for them At Column A and then Run Macro Once. Otherwise for Each Input ID you should Macro One Time to Get ID from InputBox.

thanks

 

[rzml]

Are you want to input student ID at Input Box and then VBA or Vlookup return other data based it
For Vlookup:

=VLOOKUP(A2,Sheet1!$A$1:$E$25,2,FALSE)

Change Sheet1!$A$1:$E$25 to your Source Range Address at sheet1
Change 2 to column of result you want for each column

was hoping to enter vlookup value is VBA made input box, it will continue to fetch the marks until there are no longer ID.

 

[rzml]

Hi rzml,

Kindly share the sheet having data.

Thanks,
Saurabh

I shared the sheets above