|You need to be more specific with you requirements.|
re: "I have a client list that runs down a column"
re: "the dates run across a row at the top"
re: "it generates a log on Sheet2 with the clients name & the date"
Where on Sheet2 is this "log" supposed to go? At the bottom of Column A, e.g. names in Column A, dates in Column B, with each new entry going at the bottom of the column?
re: "add a pre-entered message... "
I'm not sure what a "pre-entered message" is.
re: "...beside each log entry"
Does "beside" mean Column C, assuming names in Column A and dates in Column B?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.