Excel Table Auto Populating an Error how do i correct it?

[daleholden]

[FONT=&quot]HI Guys I have an excel table where I enter sales after the sale has completed I have a macro that sets the line and moves me down to the next line. This new line holds all the calculations from when the table started. But I had an error with a live feed which is now sorted but this has created a #REF link error I have corrected it but every time it copies to next line the error is carried forward. How can I fix it, please?[/FONT]

 

[daleholden]

Ignore fixed guys