Update sheet code automatically

**matrixpom** · 12-06-2012, 11:20 PM

Good day all,

I have attached a code to a sheet ("PAGE 3") that based on the cell value of "D10" finds & copies the relevant named range from "List" to the sheet, now this works if entered directly into cell "D10", however this cell will eventually be populated by another sheet (Sheet1 - D5) but when I do this the sheet code doesn't update, is there an easier way to do this or a simpler code that updates automatically? Sample attached, Thank you all & have a great day - Marco

**nilem** · 12-07-2012, 12:06 AM

Hi, Marco
Worksheet_Change event does not occur when calculations lead to the appearance of another value formula. So try to use the Worksheet_Calculate event.

**matrixpom** · 12-07-2012, 01:55 AM

Hi Nilem,

Tried changing to "Worksheet_Calculate" sadly this still doesn't update when I go back to "PAGE 3"? This is my code so far...thanks again for any help - Marco

Please Login or Register  to view this content.

**nilem** · 12-07-2012, 02:15 AM

something like this

Please Login or Register  to view this content.

Blocks QLD, NSW, etc. (on sheet "List") should be separated from each other by at least one blank line.

**matrixpom** · 12-07-2012, 04:28 AM

Hi Nilem,
You'll have to excuse my ignorance here but I've tried all & still no luck I'm afraid...I've uploaded the workbook with your updates? Thanks again Nilem - Marco

**nilem** · 12-07-2012, 09:47 AM

It works for me. For example, we choose "QLD" (Sheet1 D5), and we see all that relates to the "QLD" on the sheet "PAGE 3" in cells A12:D35. Or select "NSW" and see on "PAGE 3" all data that relates to the "NSW".
Have you got it going wrong?

**matrixpom** · 12-09-2012, 07:06 PM

Hi Nilem,

You were right, my spread sheet was on manual update, don't know how or when it changed from auto but none the less thank you very much & have a great day!

- Marco