Dear Senior member
I would like request you to guide vba code as example: loop sheet1 to sheet3 then paste data insert cell down to sheet "Master" as information below
I would like request you to guide vba code as example: loop sheet1 to sheet3 then paste data insert cell down to sheet "Master" as information below
Sheet1 | Sheet2 | Sheet3 | Master | |||||||||||
No. | Menu 1 | Menu 2 | No. | Menu 1 | Menu 2 | No. | Menu 1 | Menu 2 | No. | Menu 1 | Menu 2 | |||
1 | abc | abc | 1 | hello | hello | 1 | Good | Good | 1 | abc | abc | |||
2 | abc | abc | 2 | hello | hello | 2 | Good | Good | 2 | abc | abc | |||
3 | abc | abc | 3 | hello | hello | 3 | Good | Good | 3 | abc | abc | |||
4 | abc | abc | 4 | hello | hello | 4 | Good | Good | 4 | abc | abc | |||
5 | abc | abc | 5 | hello | hello | 5 | abc | abc | ||||||
6 | abc | abc | 6 | hello | hello | 6 | abc | abc | ||||||
7 | abc | abc | 7 | abc | abc | |||||||||
8 | abc | abc | 8 | abc | abc | |||||||||
9 | abc | abc | 9 | abc | abc | |||||||||
10 | abc | abc | 10 | abc | abc | |||||||||
11 | abc | abc | 11 | abc | abc | |||||||||
12 | abc | abc | 12 | abc | abc | |||||||||
13 | abc | abc | 13 | abc | abc | |||||||||
14 | hello | hello | ||||||||||||
15 | hello | hello | ||||||||||||
16 | hello | hello | ||||||||||||
17 | hello | hello | ||||||||||||
18 | hello | hello | ||||||||||||
19 | hello | hello | ||||||||||||
20 | Good | Good | ||||||||||||
21 | Good | Good | ||||||||||||
22 | Good | Good | ||||||||||||
23 | Good | Good | ||||||||||||