Help Pasting using one button

[WhisperSilence]

Hello all, I have 2 excel sheets attached. I need help pasting from one sheet to the other.

The process is as follows: The Case No(Column A) goes on the very top of the sheet on the right. Then the Item No.(column D) goes right above the bar code. That isn't the only thing I would like however.

The problems occur when the Item No. has 2-4 data points in which I would use the extra boxes I have on the sheet on the right. I also don't want any blanks. For each Case No there is only one page so I would also need to print said paper and then clear it and have it run again until it goes through the list.

So far I have thought of using dictionary and for but I have not been very successful. All help is greatly Appreciated!


Thanks