Consulting

Results 1 to 7 of 7

Thread: Record change of value in cell/s

  1. #1
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,258
    Location

    Record change of value in cell/s

    In the attached workbook I have 20 hives. Anytime a value changes in a value within a row, I need to be able to record on a second sheet that particular change. I am looking for a method of recording an action taken on any hive, on a date of recording, whether it be a change of Location, Description, Bodies, Date or Action. The Change of value needs to be recorded on a second sheet.

    Okay before anyone suggests otherwise, Yes this is not normally an Excel type operation. The vast majority of our association might know how to use an Excel spreadsheet (hopefully), and I need a way of recording any operation they might carry out on their hive/s an a particular date. Each member will have their own spreadsheet.
    Attached Files Attached Files
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,796
    Location
    Here's something to play with (I like these fun little projects )

    Formatting is fairly basic (so far) , and it doesn't handle multiple cell deletes (yet)

    Location, Description, Bodies, Date or Action
    I didn't see 'Bodies' anywhere
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,258
    Location
    Close Paul, but you are kind of on the right track.

    Any record of change needs to show the Hive ID, a date on which the change occurred, and the changed value so that over time we can show the history of activities of the Hive.

    Yes, I'll cop one on the chin for the stuff up regarding bodies. I had changed the Desc value because it occurred to me that during a 12 month period hive bodies may be added or removed during that time. I had a long long fathers day lunch with my family, before coming home to post the workbook.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,258
    Location
    I have had another think about this issue. In the attached workbook is more like what I think I want. Feel free to alter the design if you believe it needs to be.

    I would like to simply change any value in columns B to N and then double click any cell in Column O of the "Processes" worksheet to copy that row to the next row available on the "Recorded" Worksheet.
    Attached Files Attached Files
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,796
    Location
    Here's an update using the original approach and one using the second approach

    1. There are no worksheets Processes or Recorded, but I think I knew what you meant

    2. Why column O? There's nothing there. I made it so that if you DC in a hive row, col A-M that data gets recorded along with the date of change

    Play with it / them
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  6. #6
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,258
    Location
    Thank you Paul.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  7. #7
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,796
    Location
    Hope it works for you

    You can polish it with formatting, etc.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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