Sheet Code To Update Automatically

**matrixpom** · 10-15-2012, 06:57 PM

Good day all,

I have a sheet code ("Page 3") that based on one cell value ("D10") populates the relevant information from another sheet ("List"), the problem is this value ("D10") is generated from another sheet ("Form") & because of this the code doesn't update? Any help would be greatly appreciated, thank you all & have a great day,

Marco

**Jakobshavn** · 10-15-2012, 07:59 PM

You need to put sheet code on the Form sheet because the D10 value is driven from L1.

**mike7952** · 10-15-2012, 08:00 PM

remove the code from Worksheet_Change to Worksheet_Activate

Please Login or Register  to view this content.

**matrixpom** · 10-15-2012, 09:28 PM

Mike if you ever find yourself on the Gold Coast in Queensland Australia, let me know & I will happily shout you a well deserved beer! You're a lifesaver! Have a great day - Marco