hey Stephen thanks for looking at this...
I know what ur suggesting but that would pose a problem, as the data in sheet 2 gets adjusted (with some calculations before it gets sent to Sheet1), so when new data comes along, the older data would get calculated twice and distorted....

thats why i was hoping for another solution, any ideas?