tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
really need your help,
i have a sheet called "Apiler"
in column D are a list of names and in column N a list of values, if data is missing column N gives me a "#N/A"
I want a macro that can let me know these are there
so when i run the macro, i want it to Look down column N if it finds a "#N/A" in any of the cell values it brings up a mesage box saying "Please add a value for (and the name that is in coulmn D of the row with the error)
so if it was row 15 and D15 say dave it would messagebox me "Please add a value for Dave"
please help if you can
thanks
Tony
really need your help,
i have a sheet called "Apiler"
in column D are a list of names and in column N a list of values, if data is missing column N gives me a "#N/A"
I want a macro that can let me know these are there
so when i run the macro, i want it to Look down column N if it finds a "#N/A" in any of the cell values it brings up a mesage box saying "Please add a value for (and the name that is in coulmn D of the row with the error)
so if it was row 15 and D15 say dave it would messagebox me "Please add a value for Dave"
please help if you can
thanks
Tony