ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copying a column to a new sheet so that cells match. (https://www.excelbanter.com/excel-worksheet-functions/49806-copying-column-new-sheet-so-cells-match.html)

Nadeem

Copying a column to a new sheet so that cells match.
 
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.


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com