How to update a 2nd Worksheet from another Worksheet

Hello Spellbound,

What's the sheet name and the cell?

Sincerely,
Leith Ross

Hi Leith

Lets say worksheet1 is called Input and worksheet2 is called Results.

So I need the Input worksheet to update itself when B2 in the Results worksheet changes.

TIA ...spellbound

Hello Spellbound,

Change the line ActiveSheet.Calculate To Worksheets("Input")

Sincerely,
Leith Ross

Leith

We may be on the wrong track, I inserted the code in the Input worksheet but it did not work.

I am using one of my test workbooks to do some evaluation work and have attached that as it may help.

The code in the Results works fine and updates that worksheet when cell B2 changes. However for error checking purposes, I have linked this worksheet back to the Input worksheet using O2 to link the dates but I now need this worksheet to update itself when B2 in Results changes, to create the cross reference.

TIA ...spellbound

Hello Spellbound,

Replace the macro on the Results worksheet with the code below, and remove the macro from the Input worksheet.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Leith

That works fine, it will speed things up especially when I incorporate it in the main workbook project, which is much larger.

Many thanks ...spellbound