Automate worksheet update

Hello all,


l am attempting to copy the externally generated value in B5 to the correct corresponding date to column G.

Trigger for this to action would be change of value in B1(=Today)
Following this action if possible would also want to automate copy/paste formula in column I if value exists in column H.

Appreciate any help, advice or guidance.
Thanks
Alan

Unfortunately the updating of a formula such as =TODAY() is not enough to trigger some VBA code. It has to be a "physical" change such as entering the date manually.

However, you could use the workbook open event to accomplish this. Try the below in the ThisWorkbook module and it will run when the file opens.

Please Login or Register  to view this content.

You could add to the code so it only runs the first time the file is opened. i.e. only run this piece of code if there's not already a figure against today's date.

This may not work for you, but there's too little information to work with to know for sure.

BSB

Originally Posted by alan2260

would also want to automate copy/paste formula in column I if value exists in column H.

I'm not sure what you mean by this. What formula?

BSB

Thanks BSB, code works perfectly.
Regarding your suggestion what do I need to add so it only runs on first time opening?
Alan.

Try this

Please Login or Register  to view this content.

BSB

Perfect, thanks.
Appreciate your time to assist with my problem.
Alan