candidates

  1. D

    Initial population of an ARRAY in Excel

    I currently have a spreadsheet that is filled with functions and. using macros. loops through thousands of potential combinations searching for the best possible solution. This is all being done to try and match up tennis players who have competed the least amount of times against one...
  2. M

    Complicated Formula ?

    I have a spreadsheet that lists all of our candidates by name and the corresponding manager. It also includes the position number they are interviewing for. On a separate sheet, I have the position number in cell i7, I'd like $j8 to show the candidates name. If there have been 10 interviews...
  3. R

    How to output the result from existing sheets to new worksheet

    How to output the result from existing sheets to new worksheet ? What is the code in need to add in ? [Sub MissingHobbies()Dim c As Integer, h As Integer, ans As Integer ans = 9 For c = 2 To 11 ' candidates For h = 3 To 6 ' hobbies Cells(8, 1) = "Hobbies" Cells(8, 2) =...
  4. R

    Returning Missing Variables on A Merge Cell

    Hello members, I need your kind assistance with regards VBA. Attached herewith is the sample data,together with the output. For this questions, There are 5 candidates in the list and each of them will take part on their favorites sports during weekday or weekend. If they participate in a...
  5. M

    Copy several cells form multiple workbooks into a new workbook.

    Hello, I have many workbooks, each with only one worksheet, containing a wide range of data related to one candidate for a work position. I need to copy specific data from each candidate into a new workbook that will contain all the candidates so i can look in one place for all the relevent...
  6. skinnea

    Summarize on a single sheet details from all other sheets including the sheet names

    Hoping someone can help - I'm sure this is simple and I'm just dim! I have a spreadsheet that records candidates (one per sheet) and the scores they achieve on 3 tests, each test consisting of multiple elements. Each sheet will sum that candidates scores across the elements and give a total...
  7. N

    Create a visual representation of data pulled via formula (vlookup? indexmatch?)

    Iam trying to show visual representation of which agencies had what percentageof candidates on an interview slate for each department. From the examplebelow, firm 2 had two candidates on slate for the FN openings, firm 1 had 1 andfirm 3 had one. So, not only do I need a way to pull this data...
  8. H

    VBA: Copy & Paste to another sheet if condition met AND a value in the range is not already present in the target sheet

    Hi All, I am attempting to help our recruitment team test a new hiring process which requires an excel spreadsheet to manage. This is what I would like to achieve. 1. Every day, the recruiters will copy & paste the most recent applicants from our tracker system into a sheet called...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top