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.

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.

The other option might be to use Application.Worksheet.Match to determine the column number of the relevant header.

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