[ad_1]
I have a employee scorecard spreadsheet in Excel
To make the question more specific, for example: There are two tabs in my spearshhe, sheet 1 and sheet 2.
Sheet 1 is my employee scorecard main page that contains all key metrics for the employee that you pick from cell A1 in sheet 1, and Cell A1 is a drop down list that reads all employees' name from column A in sheet 2.
So every time you click cell A1 in sheet 1, you can pick the employee you want, then all the performance numbers in sheet 1 will refesh and then you can print it out and review with the employee.
So I wonder if there any easy way through VBA, that can automatically pick every employee from this drop down list and wait those numbers refresh and prind the sheet 1 out for each employee?
Thanks so much
[ad_2]
لینک منبع
