update date to 10 days after another cells date

Originally Posted by tabford

stnkynts...... when i pasted yours into a new module, for some reason it will not show up in my macros for me to run.

Maybe I can help. It's not a macro you put in a module, it's a worksheet event module.
Copy the code, right click the tab for the sheet you want the code to work on, choose view code and then paste it into the window.

Also change the A:A in the code to G:G, you didn't provide a sample sheet so stnkynts wrote it for column A, there is a note regarding that at the top of the code.

Originally Posted by tabford

I provided a sample sheet in my reply. I will try it out and i did adjust the range accordingly. thank you.

The code was written before your sample sheet. The note in the code that was written before your reply said " 'assuming column A and column B", now do you understand my statement?

Here is some code you can run from a regular module that will update all your blank cells. Select the cells in column H and run the macro. From then stnkynts' code will run automatically anytime you change a date in column G.

Please Login or Register  to view this content.