I would like someone to give me Excel vba code to Auto update or refresh Master workbook when open from Multiple workbook belongs into the same file folder
Master workbook open Automatically update from workbook1,workbook2, workbook3, workbook4 absence sheets it will look into the 4 woorkbooks if any employee on vacation, leave of absence, work insurance, ex.... see below master workbook and multiple workbook. thank you all
Master Workbook Daily Employee Schedule
22-Aug-17
No.Name Clock# Metro Crew PopcornCrew BreadedCrew formingCrew
1 Pham A. 6144 3:30
2 Tran C. 6145 3:30
3 Zhang M. 6146 2:30
4 Truong M. 6147 2:30
5 Tuong N 6148 VAC
6 Tran T 6149 3:30
7 Suwan P 6150 1:30
8 Sinh S 6151 2:30
9 Binh L 6152 3:30
10 Mercy B 6153 Training
11 Lurii B 6154 2:30
12 Lay T 6155 3:30
13 Konadu M 6156 3:30
14 Carty T 6157 VAC
15 Shankar S 6158 3:30
16 Amank A 6159 2:30
17 Lam W 6160 VAC
18 Cen J 6161 3:30
19 King A 6162 3:30
20 Rockwell D 6163 2:30
V= VAC
LO=LOA Workbook1 Bread_Time_AbsenceSheet Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Tran T
Lay T
Shankar S
Amank A v v v v
Lam W v v v Workbook2 Metro_Time_AbsenceSheet Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Pham A
Tran C
Zhang M
Truong M
King A Workbook3 Popcorn_Time_AbsenceSheet Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Tuong N V V
Sinh S
Binh L
Cen J
Rockwell D Workbook4 Forming_Time_AbsenceSheet
Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Suwan P
Mercy B
Lurii B
Konadu M v v v v
Carty T v v v v