+ Reply to Thread
Results 1 to 4 of 4

Have ID number Copy over to Edits Log

  1. 01-20-2014, 11:59 AM #1
    Cansa is offline
    Registered User
    Join Date
    09-20-2012
    Location
    La Crosse, WI
    MS-Off Ver
    Excel 2010
    Posts
    70

    Have ID number Copy over to Edits Log

    Hello!

    Currently i have embedded codes that are working perfectly for me...when i make adjustments and changes on my "Customer Data" Sheet, the log (Edits Log Sheet) is updated as i edit. The only other thing i would like to add to my log is the ID No. (Col B on the Customer Data Tab).

    Is there a code that, when the Row is updated, the ID No of that Row is also added to the Edits log?

    Full Layout Inspection Report New Template.xlsm

    Regards,
    Cansa
    Reply With QuoteRegister To Reply
  2. 01-20-2014, 12:27 PM #2
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Have ID number Copy over to Edits Log

    Hi Cansa

    Try this (untested) 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 01-20-2014, 12:47 PM #3
    Cansa is offline
    Registered User
    Join Date
    09-20-2012
    Location
    La Crosse, WI
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: Have ID number Copy over to Edits Log

    Thank you John! Your revision to this code is perfect!

    Thank you for your expertise!
    Cansa
    Reply With QuoteRegister To Reply
  4. 01-20-2014, 01:24 PM #4
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Have ID number Copy over to Edits Log

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a loop script to copy from one 'data' workbook' to a template, make some edits, save.
    By brfink2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-13-2013, 03:37 PM
  2. [SOLVED] How to add counter to monitor numberof edits and copy this data in diff cells??
    By CHETANHADIMANI in forum Excel - New Users/Basics
    Replies: 27
    Last Post: 07-20-2012, 02:25 PM
  3. Bypassing Edits
    By LAF in forum Excel General
    Replies: 2
    Last Post: 12-12-2006, 03:17 PM
  4. [SOLVED] Footer edits
    By Sheilamom in forum Excel General
    Replies: 1
    Last Post: 06-05-2006, 09:20 AM
  5. Limiting edits
    By alexandra60 in forum Excel General
    Replies: 3
    Last Post: 02-08-2006, 05:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1