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:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD]Employee ID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date Start[/TD]
[TD][/TD]
[TD]Date End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]No. Of Days[/TD]
[TD][/TD]
[TD]Reason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Employees Worksheets (will be many, same layout).
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]Date Start[/TD]
[TD]Date End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]1/4/19[/TD]
[TD]2/4/19[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DOB[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]5/6/19[/TD]
[TD]5/6/19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Date Joined[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]5/7/19[/TD]
[TD]13/7/19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD]Employee ID[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date Start[/TD]
[TD][/TD]
[TD]Date End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]No. Of Days[/TD]
[TD][/TD]
[TD]Reason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Employees Worksheets (will be many, same layout).
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]Date Start[/TD]
[TD]Date End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]1/4/19[/TD]
[TD]2/4/19[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]DOB[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]5/6/19[/TD]
[TD]5/6/19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Date Joined[/TD]
[TD]*[/TD]
[TD][/TD]
[TD]5/7/19[/TD]
[TD]13/7/19[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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