hi,
i have 2 workbook.
Wb 1 named as SCORE SHEET, contains 1 sheet where each staff will key is to key in their daily activities and there will b percentage given end off the day. Each staff requires to open this sheet, select their name, select the date /month / year then proceed to key in their data.
Wb 2 named as MASTER stored in shared drive and locked for other staff. This wb contains multiple sheets which is the staff names. All the daily data from each staff to be keyed in accordingly.
Currently all staff will save a copy and send WB1 via email and manually i have to key in data into WB2.
I hope there is macro to be set in WB1 where data from selected cells to be copied in to WB2 without opening WB2 and according to staff name and date.
Example;
WB1 (SCORE SHEET)
A1 - Staff name (John,Mary...) (there will drop down menu)
C1 - Date (dd/mm/yyyy)
J1 - Daily score (70%,30%...)
WB2 (MASTER) (contains +-50 sheets which each is named after a staff)
A1 - Staff name (John,Mary...) (fixed in each sheet according to staff)
A2 - date (dd/mm/yyyy - e.g. 01/05/2014)
A3- date (e.g. 02/05/2014) and for rest of the year.
D2 - Daily percentage
(e.g. staff A got 79% on 01/05/2014 so in WB2 sheet named staff A contains A1=staff A, A2=01/05/2014 and D2=79%)
I need a macro placed WB1 where at end off the day the staff just need to press the button and the value from WB1 A1,C1,D1,E1 & J1 copied to WB 2 into correct cells for whole year.
Hope the above clarifies
i have 2 workbook.
Wb 1 named as SCORE SHEET, contains 1 sheet where each staff will key is to key in their daily activities and there will b percentage given end off the day. Each staff requires to open this sheet, select their name, select the date /month / year then proceed to key in their data.
Wb 2 named as MASTER stored in shared drive and locked for other staff. This wb contains multiple sheets which is the staff names. All the daily data from each staff to be keyed in accordingly.
Currently all staff will save a copy and send WB1 via email and manually i have to key in data into WB2.
I hope there is macro to be set in WB1 where data from selected cells to be copied in to WB2 without opening WB2 and according to staff name and date.
Example;
WB1 (SCORE SHEET)
A1 - Staff name (John,Mary...) (there will drop down menu)
C1 - Date (dd/mm/yyyy)
J1 - Daily score (70%,30%...)
WB2 (MASTER) (contains +-50 sheets which each is named after a staff)
A1 - Staff name (John,Mary...) (fixed in each sheet according to staff)
A2 - date (dd/mm/yyyy - e.g. 01/05/2014)
A3- date (e.g. 02/05/2014) and for rest of the year.
D2 - Daily percentage
(e.g. staff A got 79% on 01/05/2014 so in WB2 sheet named staff A contains A1=staff A, A2=01/05/2014 and D2=79%)
I need a macro placed WB1 where at end off the day the staff just need to press the button and the value from WB1 A1,C1,D1,E1 & J1 copied to WB 2 into correct cells for whole year.
Hope the above clarifies