employee id's

  1. J

    Employee name replacement (macro)

    Hello, I need a macro (in a module) that can replace the employee name with the corresponding employee ID from a different sheet called "roster". I tried to attach a file as an example but could not figure out how to do it. I would greatly appreciate any help. PS: I am not good at writing...
  2. D

    Comparing cells which have common values in 2 different sheet tabs and pick the corresponding cells from sheet 2 to copy in 3rd sheet

    Greetings, Please find my scenario below, I have emp id in sheet1 and sheet2 sheet1: sheet2: empid name emp id name nominee 001 Jack 001 Jack Mary 002...
  3. A

    Picking the right Job Title between two or more dates using time sheet date and effective date employee held title

    I have a 400 MB excel workbook filled with Labor Ledger data but it is missing job titles for each line. It contains 49 columns of data and there are two ledger tabs: the first is named "1LD" and the second "2LD". I would like to focus on 2 columns within worksheets named "1LD" and "2LD" to...

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