Copying cells based on limited citeria

[ben5496]

Hello

I am trying to write a Macro that copys data from one worksheet and pastes it in the other, where it will be pasted will depend on the number of the item (as different numbers will be within two sheets) and whether or not a number has been pasted before it, if it has been pasted then the next dulipate number should be pasted into the next column across

I Have attached a example file to make my explanasion clearer.

thanks