+ Reply to Thread
Results 1 to 6 of 6

data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

  1. 07-06-2025, 04:09 PM #1
    jojo4santa
    jojo4santa is offline
    Forum Contributor
    Join Date
    12-11-2023
    Location
    los altos, ca
    MS-Off Ver
    2016
    Posts
    152

    data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    Hi Super coders

    Hope you have enough rest for the weekend while helping me. I am too busy with all the ideas non stop.
    I need your help please.
    I need to change the data cell in Book1 but the code in Book2 need to be updated.
    Could you please help?

    THanks much.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-06-2025, 06:25 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,471

    Re: data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    As you can tell by how many times your post has been viewed yet no answers provided, the readers are not fully aware
    of what you are seeking.

    Reword your goal and provide a sample to be viewed of that goal.

    Thanks.
    Reply With QuoteRegister To Reply
  3. 07-06-2025, 06:42 PM #3
    TMS
    TMS is online now
    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
    49,038

    Re: data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    Guessing that the range in the code in Book2 is hard coded. In which case, any changes to the layout of Book1 will cause the code to fail to a greater or lesser degree.

    I would suggest you define (Dynamic) Named Ranges for the ranges in Book1 and the use those instead of hard coding them.
    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
  4. 07-06-2025, 06:56 PM #4
    TMS
    TMS is online now
    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
    49,038

    Re: data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    The other option might be to use Application.Worksheet.Match to determine the column number of the relevant header.
    Reply With QuoteRegister To Reply
  5. 07-07-2025, 04:47 AM #5
    cysu11
    cysu11 is offline
    Valued Forum Contributor
    Join Date
    03-05-2025
    Location
    Deutschland
    MS-Off Ver
    MS Office Home & Business 2024
    Posts
    433

    Re: data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    Hi Jojo,

    like this, please as always, first test ist with the attached files, then with original files. Don´t forget to rename the files.

    Please Login or Register  to view this content.
    BR, Alexandra
    Attached Files Attached Files
    Best regards, Alexandra

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved"
    Reply With QuoteRegister To Reply
  6. 07-07-2025, 06:13 PM #6
    jojo4santa
    jojo4santa is offline
    Forum Contributor
    Join Date
    12-11-2023
    Location
    los altos, ca
    MS-Off Ver
    2016
    Posts
    152

    Re: data cell changed from AE37 to AF37 and AE46 to AF46, Book2 updated per change

    Thanks millions Alexandra for your super quick code that I am confident always working miraculously. All stars in the sky added to your rep. God bless you for always helping me when needed. You're such an Angel. Thanks again Alexandra.
    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. Auto change of validated cell when source in data validation changed
    By AnnieAppleBee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2022, 03:08 PM
  2. How to activate cell value change macro in a column, upon data updated
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2020, 08:48 AM
  3. Formula to enter data/change the colour of a cell if a file isn't updated
    By alexander.small in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 10:04 PM
  4. Formula to enter data/change the colour of a cell if a file isn't updated
    By alexander.small in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-01-2013, 06:41 AM
  5. Formula to enter data/change the colour of a cell if a file isn't updated
    By alexander.small in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-31-2013, 09:58 AM
  6. Change background color of cell when data has been changed
    By paperboy in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-13-2013, 05:00 AM
  7. =SUMIF(book2!L3:AF3, "=book1!O30", book2!L20:AF20)
    By dond in forum Excel General
    Replies: 1
    Last Post: 11-08-2005, 08:40 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