Have a column show in a list

[Cferron]

I have a column that I would like to replicate to another column (on a different sheet) My trouble is that this other column is in a list. Is this possible to achieve this?

Thanks

Claude

 

[texasalynn]

ok not sure I'm understanding - are you wanting a drop-down list on the other sheet of those items?

If so them select the data for the list and type a name in the name box (the box to the left of the formula bar). Then you can go to the other sheet and select Data - Validation - Allow drop down (list) - Source "name you assigned to data"

 

[Cferron]

ok not sure I'm understanding - are you wanting a drop-down list on the other sheet of those items?

No, not a drop down, just a duplicate. But here is the catch, It has to use the LIST feature. Initially a list has only one row and when you add item a new row appear. I could maybe just add an =!sheetnameA8 and so on, but I do not always have the same amount of number in the initial list.

Hope this clarify things.

Claude