In EXCEL 2007 take the following action:-

1. Enter the following information in cells G9 to G12 (of Sheet1):-

Persil
Tesco
Woolworths
Coca Cola

These are the brand names to which you refer.

You can enter this information in any cells you like but I have chosen those
mentioned above.

2. Highlight the range of cells into which you have entered the information
(I chose cells G9 to G12).

3. Do a Ctrl-C to copy the data.

4. Click on Sheet2.

The cursor will default to cell A1.

5. Home / Paste / Paste Link.

Cells A1 to A4 inclusive of Sheet2 will now contain the following data:-

Persil
Tesco
Woolworths
Coca Cola

6. Now whenever you change the information entered at number 1. above the
data in Sheet2 will change automatically.

Please hit Yes if my comments have helped.

Thanks!






"CF" wrote:

I have a row of cells with brand names. I want to copy the contents of
the row of cells to a column on another sheet. How can I achieve this
so that whenever I change a cell value on the row I also modify the
value of the cells in the column in question? I was shown how to do
this once, a long time ago, but I have forgotten. I think it involved
the Vlookup function but I am not positive about it.

Thanks...Carlos
.