tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Ok so heres what i need,
I have a sheet with employees names and there daily hours,
but the hourly rate is looked up from the employees tab,
if that employee is not listed I get a zero as there rate,
I want a macro that when i run it it check if any of the rows have a zero in the hourly rate column and if so give me that name in a pop up box,
So here's the fully details
last row can be found in column A,
Look down Column N and see if any cells in N2 to lastrow area zero "0"
if so, take the first and last names from column C and D
Now there will be lots of duplicate names, so you can get rid of any duplicate names in column D (D is set up to always be unique for each employee so just D id fine)
so we should now have a list of all the employees who do not have a rate,
give me a popup bow with "these employees don't have a rate"
then list then as Data in column C then column D
A bit like this
these employees don't have a rate
Tony Wats
Bob Holmes
Etc so this is column D
Column C
please help if you can,
Thanks
Tony
Ok so heres what i need,
I have a sheet with employees names and there daily hours,
but the hourly rate is looked up from the employees tab,
if that employee is not listed I get a zero as there rate,
I want a macro that when i run it it check if any of the rows have a zero in the hourly rate column and if so give me that name in a pop up box,
So here's the fully details
last row can be found in column A,
Look down Column N and see if any cells in N2 to lastrow area zero "0"
if so, take the first and last names from column C and D
Now there will be lots of duplicate names, so you can get rid of any duplicate names in column D (D is set up to always be unique for each employee so just D id fine)
so we should now have a list of all the employees who do not have a rate,
give me a popup bow with "these employees don't have a rate"
then list then as Data in column C then column D
A bit like this
these employees don't have a rate
Tony Wats
Bob Holmes
Etc so this is column D
Column C
please help if you can,
Thanks
Tony