Macro to copy credit value items

I have values in Col C and the data pertaining to these items in col A


I would like to copy these items and the values in Col C must be copied into Col B after the last items containing data in Col A

I have shown what the data should like on sheet "result"


It would be appreciated if someone could provide me with the code to do this

Perhaps:-

Please Login or Register  to view this content.

Regards Mick

Thanks for the help guys. Code works perfectly