+ 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. #1
    Forum Contributor
    Join Date
    12-11-2023
    Location
    los altos, ca
    MS-Off Ver
    2016
    Posts
    156

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

    ********************Another millions of millions thanks to Super Genius Alexandra for your most powerful code that works like a miracle as always. Thank you for all your hard work, quick help. I am in tears. You are the only one who makes this work impossible.to possible. May God bless you and yours always.*********************************


    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
    Last edited by jojo4santa; 07-11-2025 at 06:32 AM. Reason: Another millions thanks to Genius Akexabdra (cysu11) for another miraculous codes

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,479

    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.

  3. #3
    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,120

    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


  4. #4
    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,120

    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.

  5. #5
    Valued Forum Contributor
    Join Date
    03-05-2025
    Location
    Deutschland
    MS-Off Ver
    MS Office Home & Business 2024
    Posts
    487

    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"

  6. #6
    Forum Contributor
    Join Date
    12-11-2023
    Location
    los altos, ca
    MS-Off Ver
    2016
    Posts
    156

    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 to 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1