In my workbook cell D3 will sometimes have a member of staffs name in it other times it will be empty.
I currently have this macro associated to a button in the workbook
This presently copies a various cells from the workbook into another workbook. This all works fine but I now want to do two things.
1. When this button is pressed it updates another workbook saying that the job has been completed.
2. It only performs the above action if D3 is not empty.
I think I know how to do the former but I can't work out how to do the latter.
Bookmarks