Results 1 to 2 of 2

Macro to Enter Text in Cell B based on Change in Cell A?

Threaded View

kaletag Macro to Enter Text in Cell B... 06-14-2012, 02:47 PM
kaletag Re: Macro to Enter Text in... 06-19-2012, 11:59 AM
  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Portland, OR
    MS-Off Ver
    Excel 2010
    Posts
    2

    Macro to Enter Text in Cell B based on Change in Cell A?

    So what I have is a spreadsheet where I want to track changes when I update an assignment.

    My Project and Milestone are set and changed at certain intervals that I want to keep separate from the Notes.

    When I update/add or change an assignment, I want the Note section to automatically pull in a phrase indicated which project, milestone and assignment has changed.

    I've racked my brain trying to figure thous out in the Macros and gotten nowhere fast.

    Any help would be greatly appreciated.

    Below is a rough example of what I'm attempting to create.

    Project Milestone
    PROJ X MILE X
    Assignment Notes
    Location 1
    Location 2
    Location 3
    Location 4
    Location 5 PROJ X, MILE X - Changed to Location 5
    Last edited by kaletag; 06-14-2012 at 02:59 PM.

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