The first worksheet in my workbook is a "master" list of all items with item
name and UPC number. I have added in two colums and typed in additional
information in each column for each row item.
There are several subsequent worksheets that contain different lists of all
the items on the master list, broken down in different ways.....by location,
price, etc.
I would like to find a way to, say, on the second worksheet, highlight an
item's UPC and then Find it on the first "master" worksheet. Then, copy the
additional information on that item from that first worksheet into the item's
row on the second worksheet.
Is there a way to do this? I have no idea....would it be a Macro? Help!
Thank you!!!!!

You can either copy and paste the entire column or, you can select the entire
column and move it with the cursor. In order to move it with the cursor,
select the border of the highlighted range and drag to your desired location.

Dave
--
Brevity is the soul of wit.


"Ingrid" wrote:

The first worksheet in my workbook is a "master" list of all items with item
name and UPC number. I have added in two colums and typed in additional
information in each column for each row item.
There are several subsequent worksheets that contain different lists of all
the items on the master list, broken down in different ways.....by location,
price, etc.
I would like to find a way to, say, on the second worksheet, highlight an
item's UPC and then Find it on the first "master" worksheet. Then, copy the
additional information on that item from that first worksheet into the item's
row on the second worksheet.
Is there a way to do this? I have no idea....would it be a Macro? Help!
Thank you!!!!!