Results 1 to 16 of 16

Macro to check if data has changed and append to another cell

Threaded View

brigitteMogg Macro to check if data has... 01-18-2013, 08:15 AM
OllieB Re: Macro to check if data... 01-18-2013, 09:07 AM
brigitteMogg Re: Macro to check if data... 01-18-2013, 10:03 AM
OllieB Re: Macro to check if data... 01-18-2013, 10:28 AM
brigitteMogg Re: Macro to check if data... 01-18-2013, 10:35 AM
OllieB Re: Macro to check if data... 01-18-2013, 10:38 AM
brigitteMogg Re: Macro to check if data... 01-18-2013, 11:01 AM
OllieB Re: Macro to check if data... 01-18-2013, 11:41 AM
brigitteMogg Re: Macro to check if data... 01-18-2013, 11:55 AM
brigitteMogg Re: Macro to check if data... 01-18-2013, 01:09 PM
OllieB Re: Macro to check if data... 01-18-2013, 03:18 PM
OllieB Re: Macro to check if data... 01-18-2013, 04:58 PM
OllieB Re: Macro to check if data... 01-18-2013, 04:46 PM
OllieB Re: Macro to check if data... 01-21-2013, 10:20 AM
brigitteMogg Re: Macro to check if data... 05-14-2013, 05:06 AM
brigitteMogg Re: Macro to check if data... 05-16-2013, 11:39 AM
  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2010
    Posts
    15

    Macro to check if data has changed and append to another cell

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1