L
Legacy 400409
Guest
looking for a formula where by i enter a sheet name and it will retrieve values from that specific sheet, all sheets will have the same formatting and cell locations such as names, id, etc.
Application form:
<tbody>
</tbody>
Employees Worksheets (will be many, same layout).
<tbody>
</tbody>
Sheet Name will be same a employee id, i just want it to retrieve the information to correct cell in the application form
Thank you
Application form:
Name | Employee ID | ||
Date Start | Date End | ||
No. Of Days | Reason | ||
Department | |||
<tbody>
</tbody>
Employees Worksheets (will be many, same layout).
Name | * | Date Start | Date End | ||
Department | * | 1/4/19 | 2/4/19 | 2 | |
DOB | * | 5/6/19 | 5/6/19 | 1 | |
Date Joined | * | 5/7/19 | 13/7/19 | 1 | |
etc | |||||
<tbody>
</tbody>
Sheet Name will be same a employee id, i just want it to retrieve the information to correct cell in the application form
Thank you