#ref!

Hello,

I have a problem with a macro i am using. (attached is my spread sheet below)

On my 'un-sourced' page, in column A, you can either select Yes or No. If yes i selected and update (at top of page) is clicked, then that row is cut and pasted into the 'sourced parts' page.

My problem lies in the 'Sheet 1' page. The columns in D to F copy the values in the cells from the Un-sourced page to help work the romulas in columns H to S.

When Yes is applied to a record on the unsourced page and update is clicked, D3, E3 and F3 all change to #REF!.

I do not want this to happen. I want D3 to stay as D3 and just change the value that the new row is showing in the un-sourced page.

Can someone please stop this from happening?


unsource 2.xls


Thanks

Bump>>><<<