colleague

  1. R

    Multiple Cell Table Lookup

    Hi, I am looking for some help in finding an excel formula which will look up to manual values against a table on another sheet and give me the number in return. For example, On sheet 1 I am looking search for the following values, Colleague name and period. Within the table on Sheet 2 i...
  2. M

    Application.Username modification not working as expected

    I'm using the following to convert Application.Username which is formatted "Last, First" to "First Last". For my name, it is working, but for a colleague it is not. I am baffled. The result for my colleague is "h, John Smith". I have had her select all and retype it, and it's still not working...
  3. G

    Pivot Tables

    <tbody> Colleague TEAM Course id 123 Course id 124 Course id 125 Course id 126 Course id 127 Course id 128 Colleague 1 TEAM A Successful Successful Successful Successful Successful Successful Colleague 2 TEAM B In Progress In Progress Not Registered Successful...
  4. G

    #Value error when macro is run by colleague in Europe

    I wrote the following to remove the time from the date in a report we are provided by a vendor. When I run this macro in the US the field updates properly, but when my colleague in Europe runs the macro it returns #Value error for most of the dates. I initially thought it was just a problem...
  5. R

    VBA for using groups in a protected workbook

    Hi guys, I'm currently in the process of creating a training matrix. I designed the layout thinking I wouldn't need to go the lengths of protecting certain areas of the work sheets, but a colleague of mine has proven me wrong. I protected the sheets not realising it would stop the groups...
  6. L

    Userform data entry tool - 'get next work'

    Hello everyone, Firstly, apologies if this has already been asked on here - I've had a little search around but I can't seem to find exactly what I'm looking for. I really just need an excel guru to point me in the direction of what I need to know then I can go away and find it. So, little...

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