I'm not that good with VBA, so I was wondering if someone could help write a
function. Essentially I have a spreadsheet where the columns represent
various forms, tests, etc. that we track for new hires. Unfortunately, there
is no easy way to see all of the missing documentation. My thought is to
write a function that takes in a range of rows (e.g., b50:f50) , checks to
see if there is a value in the first cell, if there is, move to the next
cell, if there isn't write "Missing" and the column header (e.g., b1) and
then move to next cell in the range, perform the same check and concatenate
the return string. This would make the output a text string that would read
something like: "Missing B, Missing D, Missing E". Can anyone recommend an
approach I could try? Thanks in advance for your assistance!