Could you provide me with help with creating a macro to do the following please?
1. If user wishes to change the date in Column B the date currently held in column B needs to append to the data in Column C and is formatted with strikethrough.
2. If user wants to change the estimate in Column D the original estimate needs to append to data in Column E and is formatted with striokegthrough
3. If user changes the status of the project to Complete a message box appears to ask for the completed data and this is copied into column I
4. Once user has added the completion date the whole range from a-I is copied into the complete worksheet and added to next available blank line.
5. Once all data has been update I want to copy the range a2:I??end , open a word template and copy it into the bookmark area projects.
Bookmarks