I am in the process of putting together a plan classification file with automatic updating of indices, dates, designations in relation to a plan number.
In the attachment you will find the Excel file in question. Let me explain how it works.
On the first page there is a database ("Map Data") in which I manually reference the number of the plan, its designation, its index and its date. On the second page, a form ("Identification Sheet") in which all the plans concerned by the identification sheet are found with their designation, index and date. The lines are filled with the "VLOOKUP" function in relation to a plan number in the database.
My question is as follows. I would like the index box (in the identification sheet) to change to red when the index is updated in the database and to become yellow again when the "Shift" button is clicked.
I hope I have been clear enough in my explanations.
First, why does the file have a .xls extension. What version of Excel do you have?
In your file there are plenty of visual basic modules with macros that seem useless. Can you delete them and leave only the useful ones to improve understanding.
When you click on SHIFT, it updates the value from the second page (re-entered) to the first, then it replaces the value of the second page with the original formula that was there before entering the value by hand.
No, that's not it. Excuse me, I have trouble expressing myself.
When I use the excel file, I work on the "database" sheet. The database is linked to the identification sheet and is updated in parallel when I modify a clue in the database for example.
So when I change the index in the database, I want the index box in the identification sheet to turn red when I change. I also wish in a second step. By clicking on the UPDATE button, the entire index column in the identification sheet goes back to yellow (after validation of the sheet).