populating cells

Hi all,

I have a spreadsheet with 2 sheets as follows:

Sheet 1 - Cases Overview
Sheet 2 - Cases

On sheet 2 there are multiple columns of data but Im only interested in the 1st column which contains names.
On sheet 1 I want to produce a list of names that appear in sheet 2, however the names column can contain the same names. But I only need to produce them once on sheet 2.

Sheet 1

Names
name1
name2

Sheet 2

Names
name1
name1
name2
name1
name2

Hope that makes sense?

Cheers

if you copy the list of names into sheet 1 you can then use the "Remove Dupicates" function. it is in the Data menu.

Thanks for that will try it. However (I forgot to mention this) that the list on Sheet2 is ever changing so need to keep the list on Sheet1 refreshed with Sheet2 as it changes.

Sheet 1 is going to be a report sheet so need to keep the formulas to a minimum and only take up the cells required. Im thinking VBA, and although I have VBA experience I cant figure out how to do this?

Cheers

this code should automate the task, but you will still need to run it unless someone else has a different solution.

Please Login or Register  to view this content.