Userform not adding data to correct place

Hi

I need the user form to add the data to the correct rows and columns on Invoice Data - at the moment the values are not pasting in the right columns and rows, also it's not adding it to the table as extra lines when it's full. Have a feeling it has to do with defined names in name manger the spacing specified for each defined name might be incorrect.

also, there seems to be a #value error with Invoice Main for units 10,2,3 not sure whats going on there. Thought it was calculation cuz it had credit but there are others that have credit but they work.

Thanks again for helping out.