Stumped want to place resultant on another page

[bruinsrme]

Hi
My workbook has a page called Lookup and Overdue Report
Lookup - where are the data is gathered
Overdue report - the resultant of the number crunching and charts.

What I would like to the calculation be displayed on the Overdue report instead of being performed on Lookup and copied to the Overdue report

This works just fine
Worksheets("Lookup").Range("M2:M200").Formula = "=IF(AND(ISBLANK(C2),ISBLANK(D2)),"""",IF(K2=0,0,(J2/L2)))"
The math works just fine.

so I thought I would try this, and excel just laughs.

Worksheets("Overdue Report").Range("H2:H200").Value = Worksheets("Lookup").Range("M2:M200").Formula = "=IF(AND(ISBLANK(C2),ISBLANK(D2)),"""",IF(K2=0,0,(J2/L2)))"

As you can probably tell I don't do this stuff for a living, self teaching and getting a lot of help from here. Just trying to learn enough to create some tools making things a little easier for me so I don't get emails saying the formula stopped working again.
Thanks
Scott
Thanks in advance.

[HaHoBe]

Hi, Scott,

maybe like this: adjust the formula to sheet Overdue and change to values thereafter:

Please Login or Register  to view this content.

Ciao,
Holger

[bruinsrme]

very cool, thank you