PDA

View Full Version : VBA script updating values other sheet



TO_BE
09-26-2022, 12:45 AM
I am looking for a vba script that updates values in other Sheet.
The values in column "N-O-P-T-U" in sheet "delhaize" need to be updated from sheet "data".
The comparative cell in both sheets is column "C".
I am looking for a vba since sheet "delhaize" is filled earlier in the day via a VBA script so cannot put formula in the cells in sheet "delhaize".
small example attached.

arnelgp
09-26-2022, 03:20 AM
i added code in Module1 and called it in the "black" button.

TO_BE
09-26-2022, 03:24 AM
Thanks Arnelgp

snb
09-26-2022, 03:55 AM
Crossposted here:

https://www.helpmij.nl/forum/showthread.php/965639-script-cellen-bijwerken-met-voorwaarde?p=6337364&viewfull=1#post6337364