+ Reply to Thread
Results 1 to 7 of 7

Auto Logging???

  1. #1
    Registered User
    Join Date
    08-24-2007
    Posts
    52

    Auto Logging???

    Is there a way for excel to log a number from one sheet into another.

    I am creating a pricing log and I currently have about 10 sheets calculating off of my main sheet Column B.

    Every month new pricing will be entered into the main sheet Column B for all of my ingredients.

    Is there a way in a separate sheet to log automatically the numbers as they are changed?

    For example in January I enter 10.00 for an item. Can that be logged in B1 on a separate sheet.
    When I change the pricing in February to 15.00 the 10.00 stays unchanged in B1 and in column C1 the new pricing $15.00 is logged and so on...
    I have attached a spreadsheet.

    Any help would be much appreciated as always!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-02-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 2019
    Posts
    68

    Re: Auto Logging???

    I use logging in a project sheet to monitor what the receptionist does. The code below goes in the sheet you want to log (not the log sheet).
    Create your log sheet (mine is password protected - the code below has the unprotect code in it to disable for logging), create your columns in the header column.
    It also adds the user who change it and a timestamp.

    Rename the sheet & columns below (and delete / add columns you want); adjust it to fit your needs, it should work.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-24-2007
    Posts
    52

    Re: Auto Logging???

    Wow thank you, but one question!

    What part of the code am I changing to reflect the sheet name and column heading?
    Rename the sheet & columns below (and delete / add columns you want); adjust it to fit your needs, it should work.

  4. #4
    Registered User
    Join Date
    05-02-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 2019
    Posts
    68

    Re: Auto Logging???

    Please Login or Register  to view this content.
    I'm not using all my columns from the sheet I want to log (as listed in the If, ElseIf, ElseIf ..etc. code above; but those are the column headers on mine.
    The end of the code has shtLog.Cells(lngNextRow, intLevelColumn).Value = lngLevelRow for example.
    Where "Level" in there is column 3 in my main sheet, but column 2 in the logging sheet.
    In the log sheet; column 1 is the username and column 6 is the timestamp, so I'm only pulling out 2 (Level & Category) of mine; then what the value was and what it was changed to.
    The header of my log sheet looks like this:

    Attachment 675887
    Attached Images Attached Images
    Last edited by AliGW; 05-03-2020 at 05:38 PM. Reason: Please don’t quote unnecessarily!

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Auto Logging???

    @purgamentum

    Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  6. #6
    Registered User
    Join Date
    05-02-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 2019
    Posts
    68

    Re: Auto Logging???

    Understood; a while since I've been on a forum.

  7. #7
    Registered User
    Join Date
    08-24-2007
    Posts
    52

    Re: Auto Logging???

    Thank you very much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Auto open a workbook and run specified macro after logging on (Advanced VBA question)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2019, 04:29 PM
  2. [SOLVED] logging columns of data when it auto updates
    By lorryrrol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2017, 11:17 AM
  3. Auto Logging Cell Info
    By REDPOOL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-01-2017, 03:12 PM
  4. [SOLVED] Auto-logging out
    By Kevin# in forum Suggestions for Improvement
    Replies: 4
    Last Post: 01-07-2016, 11:36 AM
  5. Auto Print / Data Logging
    By Invert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2013, 04:31 PM
  6. Logging Changes
    By greasybob in forum Excel General
    Replies: 5
    Last Post: 12-15-2006, 01:56 PM
  7. logging out
    By Tom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2006, 05:50 PM

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