+ Reply to Thread
Results 1 to 4 of 4

Update field 2 from field 1 automatically

  1. 01-20-2022, 03:09 PM #1
    fatfish1969
    fatfish1969 is offline
    Registered User
    Join Date
    03-08-2019
    Location
    NEW JERSEY
    MS-Off Ver
    2019
    Posts
    74

    Update field 2 from field 1 automatically

    I would like to update field I6 from field E6 when field E6 is greater than field I6. Field E5-E16 is updated daily,
    And if possible, copy field E5 to field H6 without adding a new column.
    The same would be for field E7 thru E16 coping the values to I7 thru I16.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-20-2022, 08:34 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Update field 2 from field 1 automatically

    You would need VBA to do this.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-21-2022, 11:31 AM #3
    fatfish1969
    fatfish1969 is offline
    Registered User
    Join Date
    03-08-2019
    Location
    NEW JERSEY
    MS-Off Ver
    2019
    Posts
    74

    Re: Update field 2 from field 1 automatically

    Tried it - works great

    Thanks
    Reply With QuoteRegister To Reply
  4. 01-21-2022, 11:52 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Update field 2 from field 1 automatically

    You're welcome. Thanks for the rep.
    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. [SOLVED] Update date field when another field is changed
    By fatfish1969 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2020, 06:18 PM
  2. Calculated Field to update automatically when Pivot is Updated
    By Aoleone# in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2019, 09:24 AM
  3. How to update a field based on value in another field
    By cliff.clayman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2016, 10:01 AM
  4. Excel to automatically update field using date
    By Stevie4man in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2014, 10:24 AM
  5. How to auto update a field when the database field changes
    By hari_sudhan in forum Excel General
    Replies: 0
    Last Post: 03-20-2009, 07:15 AM
  6. Creating an overdue date field to update data automatically
    By simjambra in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-05-2009, 12:19 AM
  7. Auto Update of a field referencing to a field in another workbook
    By Camper Joe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2006, 02:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1