colleague

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...

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...

<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...

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...

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...

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...