Code to write to a cell on another sheet

**Richard Buttrey** · 08-21-2013, 08:12 PM

Hi,

I've added a small macro to the Workbook Sheet Change event and also named the N15 cells 'Over'

When you enter a Y in any of the N15 cells Sheet I4 will also be updated. If you delete a Y so too will Sheet I4 have N15 cleared.

**neil40** · 08-22-2013, 04:39 AM

Originally Posted by Richard Buttrey

Hi,

I've added a small macro to the Workbook Sheet Change event and also named the N15 cells 'Over'

When you enter a Y in any of the N15 cells Sheet I4 will also be updated. If you delete a Y so too will Sheet I4 have N15 cleared.

Richard,

Many thanks.
At first it wasn't working, the first N15 cell I tried on Sheet I1 came up with a debug error when writing Y or deleting it.
I noticed that cell didn't have the name 'Over' like the others, and once added it fixed it

Thanks again.
Neil