Hi,

I am trying to create a recruitment tool of sorts, where we can choose the department and role for which a candidate is to be assessed, then enter assessment scores for around 20 parameters, then based on these parameters , generate a fitment assessment report for each candidate. While I have done all of this, the last piece that I need to do is carry out a candidate comparison, wherein , I can view how many candidates were interviewed and how they fared. (Max. of 5 candidates would be interviewed per role).

Now for this I need to do the following

1) Create a master data sheet where every time I choose a new candidate and assess, the details of that candidate (about 30 columns of data) are populated into the master sheet - This sheet should be able to identify which is the last empty row and insert data into it.

I have attached a file here which has
1. Source for the master data: Fitness Assessment Report (attached) Test_Comparison.xls
2. Master Data" sheet with a representation of how I need the data to look like.
Note : All these columns are from formulas and not manual entry

2) From the master sheet, pick out role specific data and do a comparison. E.g., If HR manager role is chosen and I click on a button "COMPARE" it should populate the scores for the 5 candidates interviewed. - This part I can do if I populate the master data as required.

Would be great if someone can help me in this regard.

Thanks a ton !