I have a column of 2000 items. I have added another column in front of it so
that it looks like this:
Brand Item
GE 23EX
WPOOL DJ01
LG WP810
Samsung SR280
etc.

I now have the same column of items on another sheet and I want to put the
brand against each just like above. But the new sheet contains some new
items, so I cannot copy and paste the Brand column on to it. Can someone tell
me a way to do it so that the particular brand gets automatically copied
against its corresponding item on the new sheet. Thanks.